Copy all Rows from Several Sheets to 1 Sheet At Once
 

I have several sheets in a spreadsheet file that have different employee
names on them. I want to copy all of the rows that have data from each sheet
onto a single sheet. Is there a macro or short cut or anything that I can
use to do this with? The reason I ask is because there are like 70+ employee
sheets and the number of rows in each sheet varies.
--
Nothing in life is ever easy - just get used to that fact.

Copy all Rows from Several Sheets to 1 Sheet At Once
 

Check out the below link by Ron de Bruin

http://www.rondebruin.nl/copy2.htm

--
Jacob


"KennyD" wrote:

I have several sheets in a spreadsheet file that have different employee
names on them. I want to copy all of the rows that have data from each sheet
onto a single sheet. Is there a macro or short cut or anything that I can
use to do this with? The reason I ask is because there are like 70+ employee
sheets and the number of rows in each sheet varies.
--
Nothing in life is ever easy - just get used to that fact.