Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

2011-06-03 Thread NOORAIN ANSARI
Congrate Sir ji...lage raho... On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been selected as 'Most Helpful Member' for the month of May'11 He has posted 67 posts in May 2011 and helped many people through his expertise. He

Re: $$Excel-Macros$$ Dynamic file name and sum

2011-06-03 Thread Vasant
There are many approaches of doing it. I have listed two here.. Pass the month and year as parameters to the - 'UpdateFormula' subroutine. You can pass the parameters either through a worksheet change event or a userform. 'Trigger on worksheet change event in Memo sheet (all the workbooks has

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

2011-06-03 Thread Manoj kumar
Congrats Ashish, keep it up. Best, Manoj Kumar On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been selected as 'Most Helpful Member' for the month of May'11 He has posted 67 posts in May 2011 and helped many people through his

$$Excel-Macros$$ Excel File icon changed.. wanted to retrive

2011-06-03 Thread Anil Bhange
Hi members, My excel file icon got changed and shows the internal data instead of standard excel image [cid:image001.jpg@01CC2201.6DA84E00] [cid:image002.jpg@01CC2201.6DA84E00] I wanted the standard excel image as my file view and not

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

2011-06-03 Thread SANJAY SONI
Dear Ashish G,   Congratulations on a great success. It is really appreciable for winning consecutive 6 times as MOST HELPFUL MEMBER. Sanjay From: Ayush Jain jainayus...@gmail.com To: excel-macros excel-macros@googlegroups.com Sent: Thursday, 2 June 2011 10:29 PM Subject: $$Excel-Macros$$

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

2011-06-03 Thread Kal xcel
once again congratulation ashish...keep it up Kalyan On Fri, Jun 3, 2011 at 3:54 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Congrate Sir ji...lage raho... On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been

Re: $$Excel-Macros$$ Dynamic file name and sum

2011-06-03 Thread Skanda
Vasant, I will try this out and let you know. Thanks for the quick around. On Fri, Jun 3, 2011 at 1:12 AM, Vasant vasant...@gmail.com wrote: There are many approaches of doing it. I have listed two here.. Pass the month and year as parameters to the - 'UpdateFormula' subroutine. You can

Re: $$Excel-Macros$$ Excel File icon changed.. wanted to retrive

2011-06-03 Thread Kiran Kancharla
Hi Anil, Follow the below steps. Open the file click the below following steps File Properties - Summary - and Uncheck the Save Preview Picture Regards, Kiran On Fri, Jun 3, 2011 at 3:18 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi members, My excel file

Re: $$Excel-Macros$$ Formula Needed to Extract Data

2011-06-03 Thread ashish koul
see if it helps On Wed, Jun 1, 2011 at 7:07 PM, John A. Smith johnasmit...@gmail.comwrote: Need help please extracting specific data from an Excel spreadsheet into an Excel report. The arrangement of the data isn't always in the same order as shown in the attached sample. Thank you again