I add new data to the data range weekly. To get the (6) pivot tables which
look at the data to update and include the new lines, I have to go into the
wizard and redefine the data range for each pivot. There must be an easier
way.
I add new data to the data range weekly. To get the (6) pivot tables which
look at the data to update and include the new lines, I have to go into the
wizard and redefine the data range for each pivot. There must be an easier
way.
Hi Nort
frustration isn't it ... check out "dynamic ranges, naming" at
www.contextures.com/tiptech.html
for an solution
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Nort" <[email protected]> wrote in message
news:[email protected]...
>I add new data to the data range weekly. To get the (6) pivot tables which
> look at the data to update and include the new lines, I have to go into
> the
> wizard and redefine the data range for each pivot. There must be an
> easier
> way.
Thanx for quick reply. This looks like it.
MN
"JulieD" wrote:
> Hi Nort
>
> frustration isn't it ... check out "dynamic ranges, naming" at
> www.contextures.com/tiptech.html
> for an solution
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "Nort" <[email protected]> wrote in message
> news:[email protected]...
> >I add new data to the data range weekly. To get the (6) pivot tables which
> > look at the data to update and include the new lines, I have to go into
> > the
> > wizard and redefine the data range for each pivot. There must be an
> > easier
> > way.
>
>
>
JulieD,
That hit the nail on the head. Why didn't I know about offset() before!
What a useful function. Thanks again.
MN
"JulieD" wrote:
> Hi Nort
>
> frustration isn't it ... check out "dynamic ranges, naming" at
> www.contextures.com/tiptech.html
> for an solution
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "Nort" <[email protected]> wrote in message
> news:[email protected]...
> >I add new data to the data range weekly. To get the (6) pivot tables which
> > look at the data to update and include the new lines, I have to go into
> > the
> > wizard and redefine the data range for each pivot. There must be an
> > easier
> > way.
>
>
>
you're welcome .. .it is definitely a useful function - use it for all my
data validation lists / pivot table sources and Debra's explaination is
really helpful too, isn't it?
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Nort" <[email protected]> wrote in message
news:[email protected]...
> JulieD,
>
> That hit the nail on the head. Why didn't I know about offset() before!
> What a useful function. Thanks again.
>
> MN
>
> "JulieD" wrote:
>
>> Hi Nort
>>
>> frustration isn't it ... check out "dynamic ranges, naming" at
>> www.contextures.com/tiptech.html
>> for an solution
>>
>> --
>> Cheers
>> JulieD
>> check out www.hcts.net.au/tipsandtricks.htm
>> ....well i'm working on it anyway
>> "Nort" <[email protected]> wrote in message
>> news:[email protected]...
>> >I add new data to the data range weekly. To get the (6) pivot tables
>> >which
>> > look at the data to update and include the new lines, I have to go into
>> > the
>> > wizard and redefine the data range for each pivot. There must be an
>> > easier
>> > way.
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks