Hello Everyone,
I have 4 Excel sheets that are used by individual team members to input information. All 4 sheets have identical headers and the data is filled progressively. For example, if Person A has met a customer, he/she will update the sheet post the meeting. Similarly for the rest.
I have a consolidated summary sheet that has same headers as the individual sheets. I need a Macro program that can consolidate data from all the 4 individual sheets as and when they are updated. So the condition here is, that the data will be unique and pasted in different rows of the summary sheet as and when data gets filled in the 4 individual sheets. The macro should identify the unique records every single time and update the same in the summary sheet.
I hope you got the problem I am trying to portray.
Please help me to solve this issue. Thanks in Advance!
Thanks,
Varhead
Bookmarks