Hello all,

I am very new to Excel VBA and currently working on a project, one of my task is to download several reports (Excel workbook) and copy paste into Master workbook. I am thinking maybe I can make this job more efficient by using VBA.


This is the report to import, the first row's date will be today's date:
Capture.JPG

This is the destination of Master workbook (date is entire year):
Capture1.JPG
Is there any way to import data when the date is match so I can keep history data?
Right now my Vba code look like this:
Capture2.JPG


Thanks in advance!