Alok Kumar Mukherjee
New Member
Hi Seniors,
I have one Master WorkBook (eg. "Master Report.xls") and several Sub Workbooks (eg. "IPL Report 01-01-2016 to 22-12-2016.xls", "IPL Report 01-01-2017 to 14-12-2017.xls", ....and so on).
All workbooks have same header (A1 to Y1).
Now, i need to Amend data in one of the Sheets of Master Workbook for only new records from any or all of the sub workbooks, excluding duplicates.
Please someone help me to create a VBA code callable function.
Thanks in advance.
Regards.
Alok
I have one Master WorkBook (eg. "Master Report.xls") and several Sub Workbooks (eg. "IPL Report 01-01-2016 to 22-12-2016.xls", "IPL Report 01-01-2017 to 14-12-2017.xls", ....and so on).
All workbooks have same header (A1 to Y1).
Now, i need to Amend data in one of the Sheets of Master Workbook for only new records from any or all of the sub workbooks, excluding duplicates.
Please someone help me to create a VBA code callable function.
Thanks in advance.
Regards.
Alok