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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Database Changes
http://www.contextures.com/xlNames01.html#Dynamic
-- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "David" wrote in message ... 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 |
Reply |
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) |