*With regards,
**Pravin Gunjal**
**Mobile: **83418 89718**
E-Mail: **isk1...@gmail.com*
* *
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Thu, Aug 9, 2012 at 12:04 PM
Subject: Unable to increase the rows anywhere in excel file - please help
To: excel
Dear Amar
You may use the same formula
=IFERROR(INDEX(INDIRECT($D$2),C10),)
*With regards,
**Pravin Gunjal**
*
On Thu, Aug 16, 2012 at 5:18 PM, amar takale amartak...@gmail.com wrote:
Thanks to all very much.One question ask to all there are custom
formatting then error will disappear
*Can anyone inform me how it works.. Thanks!*
* *
*With regards,
**Pravin Gunjal**
*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
*Hi Smitha*
*
*
*Pl try this...*
* *
*With regards,
**Pravin Gunjal**
*
*
*
-- Forwarded message --
From: Smitha S R sperdwo...@gmail.com
Date: Mon, Aug 20, 2012 at 4:59 PM
Subject: Re: $$Excel-Macros$$ conditional formatting
To: excel-macros@googlegroups.com
The colour should
*Dear Mr. Manoj*
*
*
*Type the value first to get the total.*
* *
*With regards,
**Pravin Gunjal**
*
On Wed, Aug 22, 2012 at 2:50 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Hi,
Please help me to collect data in attached file..
Regard
Manoj
--
Join official facebook
You cant, but you can change the photo whatever you would like.
On Fri, Aug 24, 2012 at 4:05 PM, amar takale amartak...@gmail.com wrote:
Dear Pravin
Can I copy that background photo.
On Fri, Aug 24, 2012 at 3:41 PM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Amar
There would be more
*Could you please inform how to work with this ...*
On Thu, Aug 30, 2012 at 9:59 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi,
Kindly see the attached file.
Regards,
Kuldeep Singh
On Thu, Aug 30, 2012 at 1:33 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi All,
Can we
*Dear Sriram,*
*
*
*Please write a meaning full subjects for e-mails.*
*
*
*This will help us to search the mails anytime, based on the requirement.*
*
*
*Thanks.*
*Pravin*
*
*
On Fri, Aug 31, 2012 at 12:22 PM, sriram ji sriramg...@gmail.com wrote:
Dear Excel Guru,
May I know how to vlookup
] *On Behalf Of *Pravin Gunjal
*Sent:* 01 September 2012 12:58
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Required month name year from the full date*
***
** **
Dear Friends,
** **
I have attached an excel file for the subject mentioned above.
** **
In which
*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal
*Sent:* 01 September 2012 2:33
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Required month name year from the
full date
Dear Mr. Modi,
You can upload such files at online storage and may download from anywhere.
For Example : Google Drive
Regards
Pravin Gunjal.
On Mon, Sep 3, 2012 at 3:58 PM, L.K. Modi ca.mod...@gmail.com wrote:
sir thats a song file..
On Mon, Sep 3, 2012 at 3:44 PM, अनिल नारायण गवली
Pl use a meaningful subject for immediate response on your issues
On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Expert,
Please help me to find rank in attached file..
Regard
Manoj
--
Join official facebook page of this forum @
Dear Friends,
Greetings !
Request for your help on the subject matter.
I have attached the file for your reference, in which there are two
different rows which are having repetition entries and I need to count them
without deleting the records/ any of the rows.
Thank you.
Regards,
Pravin
Dear Friends,
Request to please help me on this issue.
I have attached an excel file for your reference.
I want the data to be filled in rows which has given in above columns of
the attached file.
Please help.
Thanks
Pravin Gunjal
--
Join official facebook page of this forum @
https
on this.
Thank you,
Pravin Gunjal
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem
!
*With regards,**
**Pravin Gunjal*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Pravin Gunjal.
On Thu, Sep 13, 2012 at 3:13 PM, Prince Dubey prince141...@gmail.comwrote:
Hi Shrini,
Do the following
1 : Right click on the cell
2: Select format cells
3: Select Custom under Category section
4: Type (;;;) Three Semi Colons under type heading and Click OK
thats
That's what Noorain did.
On Thu, Sep 13, 2012 at 3:50 PM, Soni.Rajender soni.rajen...@gmail.comwrote:
Hi
The same can also be done using conditional formatting.
Regards
Rajender Soni
On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote:
Dear All
If i enter 0(zero) in
Hello Rajan
Could you please inform how to use this code in outlook.
Thanks
Pravin Gunjal.
On Mon, Sep 17, 2012 at 7:58 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*I have created below macro before sometime you can use this and can add
more words condition in Red Line*
* *
*Option
**
**
*End Sub*
**
**
**
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
**
*From:* excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal
*Sent:* 06 September 2012 12:52
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel
Hi Suyog / Rajan
I have tried the same as per your guidelines but neither it's working nor
giving any MSG.
Fyi please.
Regards
Pravin Gunjal
On Tue, Sep 18, 2012 at 2:25 PM, Suyog nashi...@gmail.com wrote:
Thanks Rajan.!
Per my understanding, I need to add first OR then need to use code
.*
*
*
*Regards*
*Pravin Gunjal*
On Wed, Oct 3, 2012 at 11:43 AM, Prince Dubey prince141...@gmail.comwrote:
Hi Pravin,
Pls Note below steps what I did.
in Column C
=A2B2drag it up to C10
in Column D
=COUNTIF($C$2:$C2,C2) Drag it up to D10
Now in Cell B11 I Wrote : =SUM((B2:B11)*(D2:D11=1
help on this matter. Thank you.*
*
*
*Regards*
*Pravin Gunjal*
*
*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
*Thanks Ahmed Swapnil*
*
*
*Yes there was some date formatting went wrong in Swapnil's file.*
*
*
*Ahmed : your file is absolutely fine. *
*
*
*Thanks a lot !*
*
*
*Pravin Gunjal*
On Thu, Oct 4, 2012 at 4:08 PM, Ahmed Honest ahmedhon...@gmail.com wrote:
Dear Pravin,
PFA with Revised
*The file is good but when we click on Google Login in the file it goes
to G-Mail entrance page and it is insisting us to enter the details again
not opening the mail with the ID Password given in the excel file.*
*
*
*Regards*
*Pravin Gunjal*
-- Forwarded message --
From: Sam
*Dear Anil*
*you are already subscribed on this forum.*
*And the same thing was informed by Noorain yesterday..*
*
*
*Regards*
*Pravin Gunjal*
On Fri, Oct 12, 2012 at 2:20 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Groups,
Pl ssubcribe me ..
Thanks Regards,
Gawli Anil
*Dear Rajan*
*Please elaborate how it will work.*
*Thanks,*
*Pravin Gunjal
*
-- Forwarded message --
From: Rajan_Verma rajanverma1...@gmail.com
Date: Sat, Oct 13, 2012 at 11:39 AM
Subject: RE: $$Excel-Macros$$ Solution required
To: excel-macros@googlegroups.com
*Use
*Dear Friend,*
*
*
*Can you update on this please.*
*
*
*Regards*
*Pravin Gunjal*
*
*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
,
Please find attached files for both type (Auto and Workbook) of code.
regards,
Vijay
On 10/27/12, Pravin Gunjal isk1...@gmail.com wrote:
*Hello Mr. Paul / Vijay / Prince,*
*
*
*I have put macros in ThisWorkbook and checked but it's not working.*
*Following is the macro.*
*
*
*
Private Sub
.*
*
*
*It should be work manually (Protect/ UnProtect) and not automatically.
Please look in to this and inform. Thank you!*
*Regards*
*Pravin Gunjal*
*
*
-- Forwarded message --
From: Rajan_Verma rajanverma1...@gmail.com
Date: Mon, Oct 29, 2012 at 10:05 AM
Subject: RE: $$Excel-Macros
To Sheets.Count Step 2
Sheets(i).Delete
Next i
End Sub
On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal isk1...@gmail.com wrote:
*Dear Friends,*
*
*
*Greetings !*
*
*
*I am having an excel file (office 2007) containing 43 sheets in it and
would like to delete alternative sheets like 2-4-6 etc
*Hello,*
*Can somebody help me out on this issue *
*Thanks in advance.*
*
*
*Regards*
*Pravin Gunjal.
*
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Tue, Oct 30, 2012 at 6:58 PM
Subject: VBA enabled sheet doesn't allow to protect
To: excel-macros
that when we run macro, a message box appear and
ask for select the sheets which you want to delete and we will select the
multiple sheet which we want to delete.
Aamir Shahzad
On Thu, Nov 1, 2012 at 11:34 AM, Pravin Gunjal isk1...@gmail.com wrote:
*Dear Noorain*
*I have attached my file for your
*Hi Paul,*
*
*
*Could you please inform me the full code, so that I can apply it in the
attached file for test purpose and later on in my original file for use.*
*
*
*And thanks to all for their solutions too.*
*
*
*Regards*
*Pravin Gunjal*
-- Forwarded message --
From: Paul
*Still waiting for the reply. Thanks.
*
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Thu, Nov 1, 2012 at 12:12 PM
Subject: $$Excel-Macros$$ Fwd: VBA enabled sheet doesn't allow to protect
To: excel-macros@googlegroups.com
*Hello,*
*Can somebody help me out
*Dear Friends,*
*
*
*Is it possible to move the cursor automatically in to the cell D1 when
we hit the ENTER key.*
*Please inform.. Thank you.*
*
*
*Regards*
*Pravin Gunjal*
*
*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members
, 2012 at 3:32 PM, Pravin Gunjal isk1...@gmail.com wrote:
*Dear Friends,*
*
*
*Is it possible to move the cursor automatically in to the cell D1
when we hit the ENTER key.*
*Please inform.. Thank you.*
*
*
*Regards*
*Pravin Gunjal*
*
*
--
Join official facebook page of this forum
*Yesit's working fine... This is what I wanted.*
*Thanks a lot ! Raja*
*
*
*Regards*
*Pravin Gunjal.
*
-- Forwarded message --
From: RAJA SEKAR apkra...@gmail.com
Date: Sat, Nov 3, 2012 at 10:03 PM
Subject: Re: $$Excel-Macros$$ Can cursor will go to cell D1 when we press
.*
*
*
*Please inform. Thanks,*
*
*
*Regards*
*Pravin Gunjal.** *
-- Forwarded message --
From: ashish koul koul.ash...@gmail.com
Date: Mon, Nov 5, 2012 at 10:43 PM
Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
To: excel-macros@googlegroups.com
check the attachment see
*you mean to say that the formula should be changed automatically, whenever
you create a new sheet?
*
-- Forwarded message --
From: Manoj Kumar manoj.11...@gmail.com
Date: Wed, Nov 7, 2012 at 2:05 PM
Subject: Re: $$Excel-Macros$$ Sum required from different sheet..
To:
*Dear Mr. Ayush*
*
*
*Done it again.*
*
*
*Regards*
*Pravin Gunjal*
-- Forwarded message --
From: Ayush Jain jainayus...@gmail.com
Date: Sat, Nov 10, 2012 at 2:37 PM
Subject: Re: $$Excel-Macros$$ discussexcel formula quiz 1
To: excel-macros excel-macros@googlegroups.com
Dear
other column which you think is mandatory to fill
SUM(April:March!H26)/COUNT(April:March!J4)
On Mon, Dec 3, 2012 at 10:04 AM, Pravin Gunjal isk1...@gmail.com wrote:
*Hello,*
*Can anybody help me to get the solution. Thanks.*
*
*
*Regards / Pravin
*
-- Forwarded message
*Can anybody solve this problem.*
On Mon, Dec 3, 2012 at 10:04 AM, Pravin Gunjal isk1...@gmail.com wrote:
*Hello,*
*Can anybody help me to get the solution. Thanks.*
*
*
*Regards / Pravin
*
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Sat, Dec 1
*Really a very good information. *
*Thanks,*
*
*
*Regards / Pravin.*
-- Forwarded message --
From: Paul Schreiner schreiner_p...@att.net
Date: Fri, Nov 30, 2012 at 7:48 PM
Subject: Re: $$Excel-Macros$$ Scraping data from image
To: excel-macros@googlegroups.com
--
Join official
*Hi Rakesh *
*
*
*You may use this following formula.*
*
*
*B2 is a cell address suppose to be a cell of birth date.
*
*
*
*=Age is DATEDIF(B2,TODAY(),y) Years, DATEDIF(B2,TODAY(),ym)
Months and DATEDIF(B2,TODAY(),md) Days*
*
*
*Regards*
*Pravin.*
-- Forwarded message --
From:
*FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.*
-- Forwarded message --
From: Dhaval Shah todhavals...@gmail.com
*Mr Neeraj,*
*Pl always write the useful subject to your mails to get immediate response
on your queries...*
*
*
*Regards,*
*Pravin.
*
On Mon, Dec 10, 2012 at 5:02 PM, neeraj chauhan
neerajchauhan...@gmail.comwrote:
Dear Experts,
kindly find the attached sheet, this long file i am not able to
*Good one. Thanks Anoop.*
-- Forwarded message --
From: Anoop K Sharma aks.sharm...@gmail.com
Date: Tue, Dec 11, 2012 at 8:19 AM
Subject: Re: $$Excel-Macros$$ Pl Solve my date query
To: excel-macros@googlegroups.com
ave a look at attached file.
--
Join official Facebook page
*Hi Amar,*
*
*
*Pl be noted that, I am not Prince and I am Pravin.*
*
*
*Also note that you can change the animation effects by changing it's
parameters as per your requirement.*
*
*
*Regards*
*Pravin Gunjal
*
-- Forwarded message --
From: amar takale amartak...@gmail.com
Date: Wed
-macros@googlegroups.com
Hi Pravin,
Whenever you move from one cell to other Worksheet_SelectionChange event
is called thats why it is not allowing you to update the sheet.
Regards
Prince
On Thursday, December 13, 2012 1:24:00 PM UTC+5:30, Pravin Gunjal wrote:
*Dear Friends,*
* *
*I am
*This link may help you :* http://www.contextures.com/excelfiles.html#Pivot
*Regards*
*Pravin.*
-- Forwarded message --
From: SHAIL GROUPS shail.gro...@gmail.com
Date: Thu, Dec 13, 2012 at 12:10 PM
Subject: $$Excel-Macros$$ i want use pivot table in multi sheet of excel
2007
To:
, Pravin Gunjal wrote:
Hi Prince
Then please let me know , how can I do the changes.
Regards
Pravin.
-- Forwarded message --
From: Prince prince...@gmail.com
Date: Thu, Dec 13, 2012 at 2:09 PM
Subject: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual
protect
*Dear Sir,*
*
*
*It would be better, if you send those calenders to see.*
*Thank you,*
*
*
*Regards*
*Pravin Gunjal*
-- Forwarded message --
From: Paul Schreiner schreiner_p...@att.net
Date: Fri, Dec 14, 2012 at 12:41 AM
Subject: $$Excel-Macros$$ Re: Dynamic calendar quiz
*Dear Amar,*
*
*
*Pl share the test file.*
*
*
*Regards*
*Pravin Gunjal.*
*
*
On Fri, Dec 14, 2012 at 5:50 PM, amar takale amartak...@gmail.com wrote:
Dear Experts
Pls can anybody help me on this matter.
As always, Thank you very much for all the help
Regards
Amar
On Thu, Dec 13, 2012
*Dear Sanjay*
*Also use a meaningful subject's to your mails...*
*Regards*
*Pravin.
*
-- Forwarded message --
From: अनिल नारायण गवली gawlianil8...@gmail.com
Date: Mon, Dec 17, 2012 at 10:43 AM
Subject: Re: $$Excel-Macros$$ Help Please
To: excel-macros@googlegroups.com
Dear
Here it's working. Thanks.
-- Forwarded message --
From: NOORAIN ANSARI noorain.ans...@gmail.com
Date: Mon, Dec 17, 2012 at 2:04 PM
Subject: Re: $$Excel-Macros$$
To: excel-macros@googlegroups.com
Dear Karan,
Please try
Hi Lalit,
Can we give different passwords to access this file to authorised users..
Regards
Pravin Gunjal.
-- Forwarded message --
From: Lalit Mohan Pandey mohan.pande...@gmail.com
Date: Fri, Dec 21, 2012 at 7:26 PM
Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised
:39:35 PM UTC+5:30, Pravin Gunjal wrote:
Hi Friends,
I have an excel file containing almost 50 sheets in it and would like to
gather all those data in a single sheet one after one (column headings may
be different)
Is there any way/VB code which can do it faster. Thank you,
Regards
Pravin
It's absolutely working fine.
Pravin Gunjal
-- Forwarded message --
From: Prince prince141...@gmail.com
Date: Wed, Jan 2, 2013 at 11:20 AM
Subject: $$Excel-Macros$$ Re: how to remove space between numbers only.
To: excel-macros@googlegroups.com
Hi Manoj,
use this this may
*To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com*
-- Forwarded message --
From: Praveen Golash praveen.gol...@gmail.com
Date: Wed, Jan 2, 2013 at 5:36 PM
Subject: $$Excel-Macros$$ Re: Please unsuscribe
To: excel-macros@googlegroups.com
To
good solution viper..
On Wed, Mar 6, 2013 at 3:51 PM, The Viper viper@gmail.com wrote:
=SUBSTITUTE(A1,CHAR(10), )
On Wed, Mar 6, 2013 at 3:30 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi,
I want to remove all enter.
Regards,
Kuldeep Singh
--
Are you =EXP(E:RT) or
Dear Friends,
Is it possible to make freeze for unique row column at a time for many
sheets?
Hope to get the solution.
Thank you,
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
updation error
To: excel-macros@googlegroups.com
Hi Pravin,
Just Click on Edit Link spot the start up option and then select the first
option dont display and update the link. Enjoy.
regards
Prince
On Tuesday, March 26, 2013 10:34:50 AM UTC+5:30, Pravin Gunjal wrote:
Hi,
I am getting
Also the same message is getting displayed while the opening the file every
time. Even if we clicked as per the guidelines.
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Tue, Mar 26, 2013 at 1:47 PM
Subject: Fwd: $$Excel-Macros$$ Re: Source Link updation
the below instructions
press Alt + E +K for check source file
then
check source file available or not in location
.
Enjoy
Team XLS
On Tue, Mar 26, 2013 at 10:34 AM, Pravin Gunjal isk1...@gmail.com wrote:
Hi,
I am getting the following error message, while opening
it..
.
Enjoy
Team XLS
On Tue, Mar 26, 2013 at 3:15 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hi Xlstime,
There are four sources are displaying there in this file. Out of which
two are available in my computer and two are not saved.
But this is to inform you that I have
Thanks for reply Anil.
Is I informed in trailer mail that, I have 4-5 files like this and I need
to do the same process in all the files, which will be a lengthy process,
hence asked for help.
Regards
Pravin Gunjal.
-- Forwarded message --
From: अनिल नारायण गवली gawlianil8
Can we change the print settings at a time for multiple sheets, as i have
an unique data in each sheet.
Please help.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
By using below event of workbook
*Private Sub Workbook_BeforePrint(Cancel As Boolean)*
*End Sub*
you can specify the different print settings for different sheets
On Monday, 1 April 2013 15:39:17 UTC+5:30, Pravin Gunjal wrote:
Can we change the print settings at a time for multiple sheets
Hello Friends,
Greetings !
How can I do Protect / Unprotect All Sheets at a time with the following
only two options :-
Also when I go for unprotect all sheets system should ask user the password.
[image: Inline image 2]
Please help me in this task. Thank you,
Regards
Pravin Gunjal
for protection.
Regards
Pravin Gunjal.
On Wed, Apr 3, 2013 at 10:46 AM, xlstime xlst...@gmail.com wrote:
Sub Protect()
' Loop through all sheets in the workbook
For i = 1 To Sheets.Count
' Activate each sheet in turn.
Sheets(i).Activate
response = MsgBox(Do
in excel. i want to copy the mail sent
time and mail subject only.
On 9 April 2013 16:40, Pravin Gunjal isk1...@gmail.com wrote:
Directly you can go to the sent box and select all of them and hit Ctrl+C
(copy) and then go to excel file and paste. Pl confirm.
-- Forwarded message
Thanks.
On Tue, Apr 9, 2013 at 10:07 PM, Shiva Prasad shivaprasad1...@gmail.comwrote:
Dear pravin,
plase find the attached example sheet.
this is the formula.
=VALUE(MONTH(D12)-YEAR(D12))
regards,
shivaprasad
On Tue, Apr 9, 2013 at 4:43 PM, Pravin Gunjal isk1...@gmail.com wrote
*You're welcome..Prabhu.*
On Wed, Apr 10, 2013 at 11:26 AM, Prabhu Pinky prabhupin...@gmail.comwrote:
Hi Pravin Gunjal
[?] Wowww its working... thanks a lot lot lot.. you saved my lots of lots
of time thanks again for your extraordinary tip.
On 10 April 2013 10:04, Pravin Gunjal
Dear Friends
I would like to delete the repeated row from the attached sheet.
E.g. Row No. 3, 5, 7 and so on up to row no.5000
Can someone help me to this by macro. Thank you,
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT
_
Columns:=3, Header:=xlYes
Application.ScreenUpdating = True
MsgBox Removed Duplicate in C coloumn, vbInformation,
Removed
End Sub
Regards,
Chaya
On Sat, Apr 13, 2013 at 10:03 AM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Friends
:=Array(2, 3), _
Header:=xlYes
Might help you out.
Regards,
Chaya
On Mon, Apr 15, 2013 at 11:12 AM, Pravin Gunjal isk1...@gmail.com wrote:
Hi Chaya
It must be check in col. B C and not only C. Pl check and inform.
Regards
Pravin.
On Mon, Apr 15, 2013 at 11:08 AM, Chaya
:
Do you want the Doc. No. after you fill column a and c or what and what
should be the doc no how we decide.
On Monday, 15 April 2013 11:09:35 UTC+5:30, Pravin Gunjal wrote:
*Hi, I want the result : Doc. No. to be come when the stockist and
location is getting typed in column C
g_blnUpdate = False Then
g_blnUpdate = True
.Unprotect
End If
End With
End Sub
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
Cheers!!
On Thu, Apr 18, 2013 at 11:50 AM, Pravin Gunjal isk1...@gmail.com wrote:
Hello,
How can I use the following macro for multiple sheets (this is placed in
Module) :-
Public g_blnUpdate As Boolean
Public Sub Protect_Unprotect()
With ThisWorkbook.Worksheets(Sheet1
= True Then
g_blnUpdate = False
.Protect
ElseIf g_blnUpdate = False Then
g_blnUpdate = True
.Unprotect
End If
End With
Next
End Sub
regards
prince
On Thursday, April 18, 2013 11:50:27 AM UTC+5:30, Pravin Gunjal wrote
Hi Preeti,
Can we do Unprotect All also?
But system should ask the password as usual for protect unprotect.
Regards
Pravin.
On Tue, Apr 23, 2013 at 9:29 PM, priti verma pritiverma1...@gmail.comwrote:
Hi Kuldeep,
Please use the following code
Sub ProtectAll()
Dim sheet As Worksheet
Dim
*Thanks will try for the same*
*
*
*Regards,*
*Pravin Gunjal.*
-- Forwarded message --
From: xlstime xlst...@gmail.com
Date: Fri, Apr 26, 2013 at 7:26 PM
Subject: Re: $$Excel-Macros$$ Protect All Sheets Via VBA
To: excel-macros@googlegroups.com
Hi Pravin,
i have just add
Hi,
The sample file is attached , in which I want the serial numbers to come
automatically based on the Invoice Numbers changes.
Thanks,
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
, Pravin Gunjal isk1...@gmail.com wrote:
Hi,
The sample file is attached , in which I want the serial numbers to come
automatically based on the Invoice Numbers changes.
Thanks,
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW
Dear Abhishek,
While checking I observed that the serial numbers are not coming properly,
as required.
Please recheck the same, Thanks,
Regards
Pravin Gunjal.
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Thu, May 2, 2013 at 3:23 PM
Subject: Fwd: $$Excel
Dear Abhishek,
This is working with blank cells also, can we avoid it, when the next cell
is blank.
Pl see the attached file. Thanks for your efforts.
Regards
Pravin Gunjal.
-- Forwarded message --
From: Abhishek Jain abhishek@gmail.com
Date: Thu, May 2, 2013 at 4:04 PM
*Very kind of you.. Thanks Abhishek.*
-- Forwarded message --
From: Abhishek Jain abhishek@gmail.com
Date: Thu, May 2, 2013 at 5:23 PM
Subject: Re: $$Excel-Macros$$ Serial numbers to come based on the changed
entry
To: Pravin Gunjal isk1...@gmail.com
Cc: excel-macros
Hello,
Is there anyway to give restriction to open a folder.
Thanks,
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise
, Pravin Gunjal isk1...@gmail.com wrote:
Hello,
Is there anyway to give restriction to open a folder.
Thanks,
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
different user id on same or another machine connected to each other that
can be done by changing properties of a folder.
propertiesSecurity then select user to provide restriction type.
Regards,
Anoop
Sr. Developer
On Fri, May 3, 2013 at 11:32 AM, Pravin Gunjal isk1...@gmail.com wrote:
Hello
Hi Anoop,
Could you explain more..
On Fri, May 3, 2013 at 12:40 PM, Anoop K Sharma aks.sharm...@gmail.comwrote:
You can restrict the first hand user (except administrator) by restricting
him instead of giving full control.
On Fri, May 3, 2013 at 12:27 PM, Pravin Gunjal isk1...@gmail.com
*With Simple Formula.*
-- Forwarded message --
From: Kuldeep Singh naukrikuld...@gmail.com
Date: Thu, May 23, 2013 at 2:35 PM
Subject: Re: $$Excel-Macros$$ HELP REQUIRED - TOP 3 VALUES
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Hi,
PFA...
Regards,
Pl share your file with group.
And use the appropriate subject for your query.
On Tue, May 28, 2013 at 6:44 PM, Prabhu Pinky prabhupin...@gmail.comwrote:
Nope I have selected only one cell in only one sheet.
Prabhu R
On May 28, 2013 3:50 PM, David Grugeon da...@grugeon.com.au wrote:
in word file
http://www.walkernews.net/2009/04/24/how-to-embed-swf-file-or-shockwave-flash-object-in-microsoft-word-2007/
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 5:12 PM, Pravin Gunjal isk1...@gmail.com wrote:
May I know how to play the video in Word file, as I couldn't
HI,
Is anybody having an example file how to make family tree.
Suggestions / advice are welcome.
Thanks,
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
Dear Mr Vijay,
I am unable to download the file from the link given below.
Is it possible to make family tree in an excel file?
Regards
Pravin Gunjal.
-- Forwarded message --
From: P.VIJAYKUMAR vijay.4...@gmail.com
Date: Thu, May 30, 2013 at 8:34 PM
Subject: Re: $$Excel-Macros
Is it possible to insert the same picture in many sheets of an excel file.
If so request to please provide the solution.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
Dear Mr Ashish
The file is attached with picture/logo which is very simple. I want this
picture/logo (or any other picture/logo) to be inserted in all the sheets
at a time. Is it possible in excel?
Thanks in advance.
Regards
Pravin Gunjal.
-- Forwarded message --
From: ashish
I have attached a sample file with logo of a company. I want this logo (or
any other picture/logo) to be inserted in all the sheets at a time. How
this can be done, please advice.
Thanks in advance.
Regards
Pravin Gunjal.
-- Forwarded message --
From: ashish koul koul.ash
1 - 100 of 229 matches
Mail list logo
