Copy all Rows from Several Sheets to 1 Sheet At Once

K

KennyD

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update several ppt documents from a single excel file 0
Linking Rows Between Sheets When Sorting 1
Re-title multiple MS Project .mpp files at once 0
Possible to have multiple sheets refer to a master template sheet? 1
Bugs in Office 2019 0
Copy rows to new sheet based on value in column A 0
Integrating information from Word to Excel (not mail merge) 1
copy rows to multiple sheets 1

Top