Re: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

2011-08-25 Thread dguillett1
Change "" to 99 if numbers in col a of source sheet -Original Message- From: dguillett1 Sent: Thursday, August 25, 2011 8:06 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet I woul

Re: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

2011-08-25 Thread dguillett1
nt Stevens Sent: Wednesday, August 24, 2011 12:45 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet Help: I have 40 spreadsheets in one workbook. I update the spreadsheets daily. I want the last row (Values) on all 40 spreadshe

Re: $$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

2011-08-24 Thread ashish koul
Hi Can you attach the sample file . also do you like to copy complete row or any specific cells only On Wed, Aug 24, 2011 at 11:15 PM, Clint Stevens wrote: > Help: I have 40 spreadsheets in one workbook. I update the > spreadsheets daily. I want the last row (Values) on all 40 > spreadsheets c

$$Excel-Macros$$ Copy the Last Row (Values) of Multiple Sheets to a Summary Sheet

2011-08-24 Thread Clint Stevens
Help: I have 40 spreadsheets in one workbook. I update the spreadsheets daily. I want the last row (Values) on all 40 spreadsheets copied to a summary sheet everyday after I update the data. How do you do this? After the data is summarized and I review it I will then delete the data in the summary