PDA

View Full Version : VBA open another Workbook copy and paste if condition is met



Jasonwang102
09-19-2019, 01:30 PM
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:
25122

This is the destination of Master workbook (date is entire year):
25123
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:
25124


Thanks in advance!