Videos
I want to be able to add and update info in the 12 sheets throughout the year and it should automatically capture this data in the masterlist without duplicating any data, but it should also slot the new info into the correct row on the master list (not necessarily the first empty row)
Hi,
1/ save your workbook as xlsm (macros enabled workbook)
scenario
existing data in your workbook
12 sheets (jan, feb,.... dec)
and a MASTER sheet
pic1
?
Additionally, it is worth noting that this real-time information capture mechanism will obviously cause significant lag in the workbook. I think it would be better to update the master table content periodically by manually running a macro.
If you have any thoughts or updates, please feel free to share them with me.
Best Regards,
Jonathan Z - MSFT | Microsoft Community Support Specialist