abraham30
06-30-2018, 11:20 PM
Hi Expert,
In the pivot sheet, one pivot table is available where I am entering date in "New Cal date" column. The time when I entered in this column for selected country and product, the same date must be populated in "Master sheet" in "Calendar date" column.
As this is a pivot table, how can I link this column to populate the data.
e.g. for China on Nestle product, if new calender date '23-Jun-2018' is entered for pivot sheet, then the same date must be reflected on column 'O' of "Master sheet".
In the pivot sheet, one pivot table is available where I am entering date in "New Cal date" column. The time when I entered in this column for selected country and product, the same date must be populated in "Master sheet" in "Calendar date" column.
As this is a pivot table, how can I link this column to populate the data.
e.g. for China on Nestle product, if new calender date '23-Jun-2018' is entered for pivot sheet, then the same date must be reflected on column 'O' of "Master sheet".