Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine data (not consolidate) from separate tabs to one?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine data (not consolidate) from separate tabs to one?
Hi Rowema,
Copy and paste is the easiest. -- cheers, Shane Devenshire "Rowema" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine data (not consolidate) from separate tabs to one?
See
http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rowema" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine data in columns from 2 tabs | Excel Discussion (Misc queries) | |||
How can I refresh data in pivot tables lcoated in separate tabs? | Excel Discussion (Misc queries) | |||
How can I refresh data in pivot tables lcoated in separate tabs? | Excel Discussion (Misc queries) | |||
Combine varied data from separate workbooks into one chart | Charts and Charting in Excel | |||
How do I combine data from separate Excel rows | New Users to Excel |