|
#1
|
|||
|
|||
Combining Spreadsheets, then Pivot
Hello All,
I am not super experienced with excel, so I have a question about combining worksheets. I would like to create a worksheet that combines the data in other worksheets, and then have a pivot table pull certain fields from the combined sheet, so something like the following setup: Pivot ^ Combined ^Sheet1 ^Sheet2 ^Sheet3 The sheet1-3 will be updated fairly regularly, so how do I go about adding them to the combined sheet and be able to have the range automatically update (or set the range to max of the other sheets and use criteria that only pulls if the rows contain data.) Thanks! |
#2
|
|||
|
|||
How to combine data from wroksheet
Hi,
You can combine worksheets by doing following steps. 1--Start the Consolidate Worksheets Wizard. ... 2--Select worksheets and ranges to merge. ... 3--Select the consolidation type. ... 4--Choose how you want to merge sheets. ... 5--Select the destination for the merged data. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Counting Grades on Excel Spreadsheet | Lear2016 | Excel | 1 | 01-04-2016 12:58 PM |
Can't Open Excel Spreadsheet | Lucky Luke | Excel | 0 | 03-12-2015 12:47 PM |
Labels from excel spreadsheet | Shepherdra | Mail Merge | 5 | 12-11-2014 11:26 PM |
Inserting excel spreadsheet into word doc | educpara58 | Excel | 2 | 07-28-2011 01:22 AM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |