Hello All
Desperately need your help!!

I am trying to get a VBA code which will take data from a pivot table and put this into a new table.

The problem is the cell each week changes due to the data inputted into the Pivot Table. How can I create a VBA code that will pick up the desired cell each time even if this is in a different place.

Is there a way of coding this?

Thanks for your help in advance.

Regards