Help with pivot table

[leaper]

I'm after some help with a pivot table

I have created a work book to log certain defects, and would like to use a
pivot table to show defects per unit on an improvement tracker, is it
possible to have the pivot table to shift cells to the right when it is
updated and required more columns so it doesn't overwrite data on the sheet

it would be like this

the componet fault unit numbers & Total defects are the pivot table & the
action would be the start of the manual data

Compontent Fault Unit Numbers Total Defects Action
1 2 3 4 5
Light Inop 1 1 2 xxxxxx
Bolt Loose 1 1 xxxxxx

in the refreshed table the 6th unit is added & the action etc would be
shifted to the right
==>
Compontent Fault Unit Numbers Total Defects Action
1 2 3 4 5 6
Light Inop 1 1 2 xxxxxx
Bolt Loose 1 1 2 xxxxxx

thanks in advance for any help given


Kev

 

[Peo Sjoblom]

I am not sure I understand what you mean but you can use a dynamic source
for a pivot table


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



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[RompStar]

another great resource of Excel help is the Forum at this web site:

Very good, I use both the group and that site, saved my ass plenty of
times...

try it out if you want.

http://www.mrexcel.com