I would probably also use a macro but if you have a list of sheet names in
column A and put this formula in col B and copy over and down
=INDEX(INDIRECT($A2!a:z),MATCH(,INDIRECT($A2!A:A),1),COLUMN()-1)
-Original Message-
From: Clint Stevens
Sent: Wednesday, August 24, 2011 12:45
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 would probably
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
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
clintontstev...@gmail.comwrote:
Help: I have 40 spreadsheets in one workbook. I update the
spreadsheets daily. I want the last row (Values) on