Dear experts
I have two master data in two different sheet i want apply vba to copy header of dates from pivot and paste into data range header values
In the sheet PivotCap_Rev two pivot which contains dates in both In the first pivot i want copy dates from B5 till date end and paste into C20 in sheet WizardReport and second pivot i want copy B20 till date end and paste into C29 in sheet WizardReport
In the third data range i want copy same as first pivot dates and paste into C37 in sheet WizardReport
I have worksheetfunction VBA in WizardReport sheet which is not allow to copy and paste the dates from one sheet to another
Find the attachment sheet WizardReport in red color which is my requirement.
Bookmarks