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