Re: $$Excel-Macros$$ Folder Restriction

2013-05-02 Thread Pravin Gunjal
User Id will be the same... On Fri, May 3, 2013 at 11:45 AM, Anoop K Sharma wrote: > If you trying to restrict a folder by supplying a password that can only > be possible with any foreign application. > But if you trying to restrict a folder to a person logged on using > different user id on sam

Re: $$Excel-Macros$$ Folder Restriction

2013-05-02 Thread Pravin Gunjal
Thanks. On Fri, May 3, 2013 at 11:43 AM, Abhishek Jain wrote: > There is an inbuilt feature in Windows like briefcase or something but I > didn't use it. Also there are bunch of third party software for it. The one > I prefer is Folder Lock. > > On Fri, May 3, 2013 at 11:32 AM, Pravin Gunjal wro

Re: $$Excel-Macros$$ Re: Hi Anoop

2013-05-02 Thread Mathan
Hi Anoop, Just wanted to let you know the result of implementation of your effort. It saved 35 Hours per month.. :-) Thanks again ! Mathan On Thu, May 2, 2013 at 12:47 PM, Mathan wrote: > Hi Anoop, > > It's working fine. Thanks a lot ! :-) > > Your dedication is much appreciated ! >

Re: $$Excel-Macros$$ Folder Restriction

2013-05-02 Thread Anoop K Sharma
If you trying to restrict a folder by supplying a password that can only be possible with any foreign application. But if you trying to restrict a folder to a person logged on using different user id on same or another machine connected to each other that can be done by changing properties of a fol

Re: $$Excel-Macros$$ Folder Restriction

2013-05-02 Thread Abhishek Jain
There is an inbuilt feature in Windows like briefcase or something but I didn't use it. Also there are bunch of third party software for it. The one I prefer is Folder Lock. On Fri, May 3, 2013 at 11:32 AM, Pravin Gunjal wrote: > Hello, > > Is there anyway to give restriction to open a folder. >

$$Excel-Macros$$ Folder Restriction

2013-05-02 Thread Pravin Gunjal
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,

Re: $$Excel-Macros$$ please give suggestion...

2013-05-02 Thread David Grugeon
You are more likely to get a response if you use a meaninful heading and include the details of your problem in the body of the post. Regards David Grugeon On 3 May 2013 03:33, SAJID MEMON wrote: > I have attached a file, please give me vba code of my problem which i have > explained in my fi

Re: $$Excel-Macros$$ Advanced Pivot Table Question

2013-05-02 Thread Dvd Yid
betnmtdongnai09: I respectfully thank you for your answer. You taught me something new. - nyc.actuary On Thu, May 2, 2013 at 12:43 PM, Bé Trần Văn wrote: > In the spreadsheet column for rent donation. > > > 1) Number of non-vacant units: > > View of Attachment Sheet2 > > > > 2) Percent of unit

$$Excel-Macros$$ Career In VBA

2013-05-02 Thread BRB
Hi Ayush, Hope you are doing well? I am a Professional with five years of exp. in Gen.Admin. I have a good hold on XL, till Pivot Table. I wish to pursue my career as a DBA. My req. is to guide me on the growth & the opportunities in the area of XL,VBA & SQL. request your to kindly provide m

$$Excel-Macros$$ please give suggestion...

2013-05-02 Thread SAJID MEMON
I have attached a file, please give me vba code of my problem which i have explained in my file. RegardsSajid Memon -- 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 foru

Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Abhishek Jain
You're welcome. But its not "kind" its "supportive". We all support each other here. Regards, AJ On Thu, May 2, 2013 at 6:15 PM, Pravin Gunjal wrote: > *Very kind of you.. Thanks Abhishek.* > > -- Forwarded message -- > From: Abhishek Jain > Date: Thu, May 2, 2013 at 5:23 PM

Fwd: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Pravin Gunjal
*Very kind of you.. Thanks Abhishek.* -- Forwarded message -- From: Abhishek Jain 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 Cc: excel-macros@googlegroups.com =IF(C6="","",IF(C6=C5,D5,D5+1)

Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Abhishek Jain
=IF(C6="","",IF(C6=C5,D5,D5+1)) Drag Down. On Thu, May 2, 2013 at 5:18 PM, Pravin Gunjal wrote: > 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. > > --

Fwd: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Pravin Gunjal
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 Date: Thu, May 2, 2013 at 4:04 PM Subject: Re: $$Excel-Macro

Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Abhishek Jain
Dear Pravin, Do not compare both formulas as in your file Column C was blank, I tried something there but it didn't pan out but I forgot to remove it. The actual formula is in Column F. Please see the attachment as per your file. Regards, On Thu, May 2, 2013 at 3:29 PM, Pravin Gunjal wrote: >

RE: $$Excel-Macros$$ How to create hyperlink within workbook

2013-05-02 Thread santosh subudhi
Hi, Hope the attached file meets your requirement. -- Regards Santosh santoshkumar.subu...@gmail.com Date: Tue, 30 Apr 2013 15:46:29 +0530 Subject: Re: $$Excel-Macros$$ How to create hyperlink within workbook From: gawlianil8...@gmail.com To: excel-macros@googlegroups.com; itpabdulg...@gmail.co

RE: $$Excel-Macros$$ copy the active worksheet and paste it to another workbook in a given path.

2013-05-02 Thread santosh subudhi
Hello Ravi, The code provided by you is trying to replace book 2. However I want the code to copy the sheet "Feedback" of Book 1 and paste it with the name provided in cell P2 in book2 as the last sheet and close the book2 automatically. If the book2 is not available in the path provided in P1

Fwd: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Pravin Gunjal
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 Date: Thu, May 2, 2013 at 3:23 PM Subject: Fwd: $$Excel-Macros$$ Serial num

Fwd: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Pravin Gunjal
*Thanks Abhishek.* -- Forwarded message -- From: Abhishek Jain Date: Thu, May 2, 2013 at 2:01 PM Subject: Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry To: excel-macros@googlegroups.com Please see. On Thu, May 2, 2013 at 1:13 PM, Pravin Gunjal wrote:

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-02 Thread pankaj gmail account
Thank You Abhishek Great! I was just looking for the same. in future I will try to provide a sample query or form.. Regards, Pankaj Michael On Thu, May 2, 2013 at 11:28 AM, Abhishek Jain wrote: > Dear Pankaj, > > Please see attached. Hope this is what you are looking for, if not, let me > know

Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Abhishek Jain
Please see. On Thu, May 2, 2013 at 1:13 PM, Pravin Gunjal 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 y

$$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Pravin Gunjal
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 @

Re: $$Excel-Macros$$ Export the data from one excel file to other

2013-05-02 Thread अनिल नारायण गवली
Dear Pravin, As the criteria of 25-04-2013 is not available in all the sheets so only header filed is coming on the output.xlsx file. Warm Regards, Gawli Anil On Thu, May 2, 2013 at 12:33 PM, Pravin Gunjal wrote: > Dear Anil, > > Thanks for reply and interest shown towards my query as nobody

Re: $$Excel-Macros$$ Re: Hi Anoop

2013-05-02 Thread Mathan
Hi Anoop, It's working fine. Thanks a lot ! :-) Your dedication is much appreciated ! Regards, Mathan On Thu, May 2, 2013 at 8:58 AM, Anoop K Sharma wrote: > Try this... You can change code as per your requirement. > > Regards, > Anoop > > > On Wed, May 1, 2013 at 12:25 PM, Mathan wrote: > >

Re: $$Excel-Macros$$ Tricks to hide/restrict viewing excel data in sheets

2013-05-02 Thread xlstime
Hi Pankaj, Why through VBA, Use protect sheet opetion.. find below link for reference http://www.extendoffice.com/documents/excel/935-excel-lock-protect-formulas.html . Enjoy Team XLS On Wed, May 1, 2013 at 2:28 PM, pankaj gmail account wrote: > > Dear Gurus, > > Ple