How do I combine data (not consolidate) from separate tabs to one?

R

Rowema

I have a report export that has data on multiple worksheets. Each location
has a separate worksheet. I want to combine the information from each
worksheet into one master list. Each worksheet is formatted the same with the
same columns and column headings. The number of rows varies from worksheet to
worksheet. I'm looking for a way to combine the information easily.
 

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

how do i combine excel worksheets 1
Consolidate data from worksheet (more then 65536 rows) 1
How do I combine these columns into one? 2
Combining data from multiple worksheets into one 4
Merge data from different worksheets 3
combine rows with similar data, but different fields in excel 1
consolidate data in pivot table 1
Combine Several Worksheets within a Workbook 1

Top