Hi all,
I am creating a macro that does a couple things that should in theory be easy to do, but, nonetheless is far beyond my very basic experience with VBA code.
The objective is to copy parts of a row from file 1 and paste them to Excel file 2 IF the date matches a given date on the second file.
The macro would need to perform an IF statement on every row on file 1.
I have figured out how the copy and pasting portion but need to figure out:
-how to set up the IF statement to reference another file
-how to apply said if statement to every row with data.
I am hoping I can get an example of the VBA code needed, and if not just learn a bit more about how I can accomplish my desired result.
Thanks,
Dalton
I am creating a macro that does a couple things that should in theory be easy to do, but, nonetheless is far beyond my very basic experience with VBA code.
The objective is to copy parts of a row from file 1 and paste them to Excel file 2 IF the date matches a given date on the second file.
The macro would need to perform an IF statement on every row on file 1.
I have figured out how the copy and pasting portion but need to figure out:
-how to set up the IF statement to reference another file
-how to apply said if statement to every row with data.
I am hoping I can get an example of the VBA code needed, and if not just learn a bit more about how I can accomplish my desired result.
Thanks,
Dalton