| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Database Changes
How can i make the range as a dynamic range so it selects the entire sheet
that has value it. Example This month there are 572 rows, but I will add 200 rows this month, I do not want to select the range again. I was thinking if offset might work, but do not know the whole formula. Help would be greatly appreciated. David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| Pivot Table not Updating | Excel Worksheet Functions | |||
| I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Threaded Mode
