Re: $$Excel-Macros$$ Macro required

2014-05-06 Thread Shrinivas Shevde
Dear sir, Thanks for reply but I want perfectly opposite. Thats I have a master sheet and from that it should go to indivisual sheet. Regards Shrinivas On Mon, May 5, 2014 at 8:10 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Reference File. 2014-05-05 17:21 GMT+07:00 Shrinivas Shevde

Re: $$Excel-Macros$$ Updating cost on limited item worksheet from a master worksheet

2014-05-06 Thread Vaibhav Joshi
Hi Assuming you append data in master sheet in the end, then i guess this is what you are looking for. See master sheet Latest sheet. Values are searched on product code. Cheers!! On Tue, May 6, 2014 at 1:12 AM, USMCRex usmc...@gmail.com wrote: Sorry if this is a duplicate question... I

RE: $$Excel-Macros$$ Specific Worksheet sohuld focus

2014-05-06 Thread Ravinder
You can put your code on workbook_open event and activate sheet2 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajeev Sent: Tuesday, May 06, 2014 11:57 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Specific Worksheet sohuld focus

RE: $$Excel-Macros$$ Specific Worksheet sohuld focus

2014-05-06 Thread Rajeev
Can u provide complete code as i don't know the same. Please help Regards, Rajeev From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: 06 May 2014 12:00 To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$

Re: $$Excel-Macros$$ Need Job--- Mis Executive field

2014-05-06 Thread kapil Gupta
Thanks for reply but I am stay in Delhi so I want looking the job in Delhi NCR. Thanks, Kapil Gupta -- 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

RE: $$Excel-Macros$$ Specific Worksheet sohuld focus

2014-05-06 Thread Rajeev
Thanks a lot. It is working. Regards, Rajeev From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: 06 May 2014 12:06 To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$ Specific Worksheet sohuld focus Pfa

$$Excel-Macros$$ User name and Password in Excel with Sheets

2014-05-06 Thread Nitya
Dear All, Do u have the template for below query ? Please share if you have one. Please... I was looking to set up a username/password protected workbook. I was hoping if I can make certain sheets visible depending on the username. so e.g User 1 will only get access to Sheet1 but User 2 will

Re: $$Excel-Macros$$ User name and Password in Excel with Sheets

2014-05-06 Thread Vaibhav Joshi
Hi You can check attachment, may this will help you. Cheers! On Tue, May 6, 2014 at 1:42 PM, Nitya nityanandadole...@gmail.com wrote: Dear All, Do u have the template for below query ? Please share if you have one. Please... I was looking to set up a username/password protected

$$Excel-Macros$$ Vbscript to find distinct ranges within a column

2014-05-06 Thread p178
Using Vbscript for an Excel 2010 worksheet, how can I find the start and end range of distinct values with a column ? I have a worksheet with some 200k rows, and 45 columns. 20 of such columns contain rows indicating a color value that I need to set. I have code that works but when working on

Re: $$Excel-Macros$$ Vbscript to find distinct ranges within a column

2014-05-06 Thread Vaibhav Joshi
hi can you share a small sample data.. cheers!! On Tue, May 6, 2014 at 10:59 PM, p178 tdavi...@hotmail.com wrote: Using Vbscript for an Excel 2010 worksheet, how can I find the start and end range of distinct values with a column ? I have a worksheet with some 200k rows, and 45 columns.

Re: $$Excel-Macros$$ Re: VBA Job @ Ernst and Young , Gurgaon

2014-05-06 Thread Xls Time
Dear KAPIL, Pls share the cv Sent from my iPad On 05-May-2014, at 10:19 pm, kapil Gupta kgupt2...@gmail.com wrote: Hello sir I need job in mis executive profile. -- 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

Re: $$Excel-Macros$$ Re: VBA Job @ Ernst and Young , Gurgaon

2014-05-06 Thread kapil Gupta
Please find the attachment files. Regards, Kapil gupta On Tuesday, May 6, 2014 11:35:04 PM UTC+5:30, XLS S wrote: Dear KAPIL, Pls share the cv Sent from my iPad On 05-May-2014, at 10:19 pm, kapil Gupta kgup...@gmail.comjavascript: wrote: Hello sir I need job in mis executive

$$Excel-Macros$$ Re: User name and Password in Excel with Sheets

2014-05-06 Thread Nitya
Dear Sir, Thanks for sharing. but x indicates right to access sheet - Does not work in it. Correct, your logic is correct but if I enter Username aa, then I am supposed to see sheet1 and sheet3 not Sheet2 (Sheet2 should hide. Thanks once again. ​​ Regards, Nitya​​ On Tue, May 6, 2014 at

Re: $$Excel-Macros$$ can not xlsm file

2014-05-06 Thread Vaibhav Joshi
Hi File size is 0 byte, it means it is already corrupted can not recover now. Thx On Wed, May 7, 2014 at 10:58 AM, hemal shah hemali...@gmail.com wrote: Dear All experts I have attached my courrpted xlsm file and error msg screen shot. Please help me to open it. -- Are you

Re: $$Excel-Macros$$ Macro required

2014-05-06 Thread Shrinivas Shevde
Dear Vaibhav Really nice and lots of thanks Small query.I will get data on daily basis as i said earlier so shall i copy paste data below the current data in data sheet. Regards Shrinivas On Tue, May 6, 2014 at 11:19 PM, Vaibhav Joshi v...@vabs.in wrote: Hey Check out this.. Cheers!!

Re: $$Excel-Macros$$ Macro required

2014-05-06 Thread Vaibhav Joshi
Hi Yes you can paste data in master file below the existing data. However you can test data. Thanks On Wed, May 7, 2014 at 11:25 AM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear Vaibhav Really nice and lots of thanks Small query.I will get data on daily basis as i said earlier so