Re: $$Excel-Macros$$ Re: Formula for auto generated code

2015-06-12 Thread Puneet Jain
Need help i have an excel sheet with lot of data which needs regular updation, in common folder having access to everybody. Is there any function by which i can track the changes in excel sheet with the name of the person and time of change. kindly help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)

Re: $$Excel-Macros$$ Re: WANT TO open FILE frequently

2015-06-12 Thread Puneet Jain
Need help i have an excel sheet with lot of data which needs regular updation, in common folder having access to everybody. Is there any function by which i can track the changes in excel sheet with the name of the person and time of change. kindly help. Puneet Jain 9899068873 -- Are you =EXP

$$Excel-Macros$$ Looking for some keyboard shortcut help in Excel 2010

2015-06-12 Thread Chris
Folks, I know I have seen this question here before but I can't find it anywhere and regret that I have to create a second post re/ this. My sincerest apologies. Please feel free to redirect my thread. However, I'm looking for the keyboard shortcut to open the menu that shows when you right-cl

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

2015-06-12 Thread MAHADEVU S M mahadev
Pankaj can you please tell where "Adobe reader file preview type library" is available in excel or in adobe and under what tab. On Sat, May 16, 2015 at 3:29 AM, Michael Vinoth wrote: > Welcome... :) > > On Friday, May 15, 2015 at 9:39:49 PM UTC+5:30, Pankaj Sharma wrote: >> >> THANK YOU Once a

$$Excel-Macros$$ Re: Conditioning formating problem with first weekday

2015-06-12 Thread Nasir Saikh
which excel version you are working As later 2010 and 2013 there is one formula which is networkdays.int On Friday, June 12, 2015 at 12:07:30 PM UTC+5:30, Maciej Piotrowicz wrote: > > hello Experts > > While using conditioning formating on dates with option next week in > default excel has sunday

$$Excel-Macros$$ Re: VBA code question !!!

2015-06-12 Thread Nasir Saikh
Mandeep, Write a code for error value and execute that code if found any error for example on error resume macrocode On Friday, June 12, 2015 at 11:27:05 AM UTC+5:30, Mandeep Baluja wrote: > > Question mentioned is in between the code > > Sub Get_unique_pincodes() > > With ActiveSheet > lr = A