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

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 ex

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

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 get

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

Hi You can check attachment, may this will help you. Cheers! On Tue, May 6, 2014 at 1:42 PM, Nitya 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 workbook. > I was hoping if

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

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

hi can you share a small sample data.. cheers!! On Tue, May 6, 2014 at 10:59 PM, p178 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. 20 of such columns

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

Dear KAPIL, Pls share the cv Sent from my iPad > On 05-May-2014, at 10:19 pm, kapil Gupta 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 page of this

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

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 > > wrote: > > > > Hello sir I need job in mis executive profile. > >

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

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

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 wrote: > Dear All experts > > I have attached my courrpted xlsm file and error msg screen shot. > > Please help me to open it. > > > -- > Are you =EXP(E:RT) or =NOT

Re: $$Excel-Macros$$ Macro required

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 wrote: > Hey > > Check out this.. > > Cheers!! > > > On M

Re: $$Excel-Macros$$ Macro required

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 wrote: > 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

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

This one takes care for same product name & with multiple retailers. Cheers!! On Tue, May 6, 2014 at 11:54 AM, Vaibhav Joshi wrote: > 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 sea

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

Thanks a ton. mind freaking solution. Thanks. Regards, Nitya On Wed, May 7, 2014 at 11:10 AM, Vaibhav Joshi wrote: > Ok, That was for testing. > > You can test on it. > > Cheers!! > > > On Wed, May 7, 2014 at 10:39 AM, Nitya > wrote: > >> Dear Sir, >> >> Thanks for sharing. but x indicates r

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

Sir, Can we make the input box of password as asterisk *. While typing the password, the password show . Thanks for the help. Regards, Nitya On Wed, May 7, 2014 at 11:47 AM, Nitya wrote: > > Thanks a ton. mind freaking solution. Thanks. > > > Regards, > Nitya > On Wed, May 7, 2014 at 11