Hi all,
I'm facing a problem and need some help to sort it out. Here is the problem.
There are 4 sheets in the workbook I’m using. The data will be entered only in the 1st sheet.
Based on the Date(s) entered in the 1st sheet the data needs to be updated accordingly in sheet 2 based on the date in sheet 1. However the data in the sheet 2 should be consolidated for each date. i.e only one entry for each date. I tried using Pivot table and getting the data from it but it’s not working. Can someone help with a Macro on this??
Please find in the attached sheet to get a more detailed view.
Thanks in Advance.
Bookmarks