Posts by adunkey10

hi,
im trying to get the last column number of the pivot table in the total extract sheet and use this to create a number to print the values in the J column automatically. can anyone help?
thanks
a10

thanks for your help! i think that i finally understand whats going on. cheers again!

i can see exactly what you are saying about about changing the 'Total Extract!$a$5:$r$235 to a named dynamic range; but because the data comes from an external data source i can't seem to create a named dynamic range. this is really killing me! is there a way around that you can see from the example sheet i posted?

i was sick all day yesterday and couldnt try it - so ill give it a go now! thanks and ill let you know how i got on!:)

sorry, i meant to say 235 rows!:barf: anyway, can i add a new row to the pivot table in the total extract sheet so that all the other pivot tables in the summary sheets are dynamically updated?

hope this makes sense!
a10

i had to take out some shhets and zip the file; i didnt mean to edit your post that time - sorry!

im not really sure what you mean, so ive attached a copy of the sheet that im working on, if you get the time, i would appreciate you taking a look at it. if i add something in the 'total extract sheet' i want the tables in the 'summary sheet' updated.

cheers

a10

Hi,
this is my second post and a little more complicated than the first to explain. say i create a pivot table from 285 columns of data and create another pivot table based on that table. my problem is that the pivot tables reamin static if i go over 285 coloumns! has this happened to anyone else and is there a way around it?

thanks

a10

thats deadly! cheers.

Hi,
I imported a load of data into a spreadsheet and it came back with a load of little squares as shown in the sample attachment. does anyone known how to get rid of these quickly?

thanks

a10