Auto transfer Pivot table values

[jimpatel1993]

Hi,

Thanks for looking at my post.

I have pivot table and i am having an issue in transfering latest updated pivot data to different workbook in different location. The scenario is below,

1. I have code for auto update pivot table
2. I am having issue in transfering latest updated data to different workbook.
Example: I have attched picture of date commencing from 25/03/21 and date commencing 27/03/21. In this example date commencing 27/03/21 is the latest data as this is the last filled column. What i am looking for is any macro which transfer all data from column A till what ever column (it varies) to othre workbook in differnt shared location. I wanted to transfer to column AA in the destination workbook please.

Any idea guys?
Any help will be appreciated.

Thanks a lot for looking at my post.
Kind regards,
Jim

[jimpatel1993]

Hi,

Thanks for looking at my post. I am having attached spreadsheet and i am having an issue in doing below condition please.
1. I have demo sheet1 which having loads of data loaded every everyday with Date column and value's column
2. I have pivot table demo in the Pivot table sheet
3. Issue is i wanted to transfer only today's date data's from pivot table column to another workbook in different location under Sheet 1 from AA column. This will be done everyday.
Any idea please?