Pivot table that references a Cell in another sheet

Hello Wil,

Try the following, this is untested but it should work as the principle is sound

Please Login or Register  to view this content.

Thanks for the reply.

It fails on
PRange = sheets.("DATA INPUTS").range("P6") .....looking for an identifier or bracketed expression

Change this

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I had too many full stops :|
You wil also need to ensure that you wrap your code segments in code tags as per the forum rules when typing your messages highlight the code and then click the # symbol.

can you post up a copy of your workbook - so I can see what changes need to be made?