hansonca1
11-14-2011, 11:00 AM
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
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