| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
| Copy Sheet to many sheets at once | Excel Discussion (Misc queries) | |||
| Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
| Copy from sheet one to several sheets | New Users to Excel | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
Linear Mode
