Pivot Table - Database Changes

[David]

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

[Peo Sjoblom]

http://www.contextures.com/xlNames01.html#Dynamic

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"David" <David@discussions.microsoft.com> wrote in message
news:9BF596D0-C064-49A8-9844-B16486CE7048@microsoft.com...
> 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