| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiple Range Pivot Table
I have two ranges of data with the same headings. One range will continuously have data added to it each month, where the other is a static row of data that gets changed each month. I need to pivot both ranges together but i dont want to add in the static data to the variable each month only to have to delete it out again. Is there away of doing this? Thanks Chris -- chalky ------------------------------------------------------------------------ chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758 View this thread: http://www.excelforum.com/showthread...hreadid=484273 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Repeats Names in multiple rows | Excel Discussion (Misc queries) | |||
| external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
| Selecting multiple filters in a pivot table | Excel Discussion (Misc queries) | |||
| how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Threaded Mode
