TheJonWithNoH
New Member
- Joined
- Sep 8, 2017
- Messages
- 30
Good Afternoon,
I have a list of file names in column B that correspond to a list of dates in column A. I am looking for a VBA code to 1) open a file and validate that the correct file has been selected (and just a message box if it is the wrong file) and 2) if the correct file was selected I need to copy cells E10:E12 from Sheet1 of that file to cells E7:E9 of my workbook.
Thanks in advance for any help you can provide!
Jon
I have a list of file names in column B that correspond to a list of dates in column A. I am looking for a VBA code to 1) open a file and validate that the correct file has been selected (and just a message box if it is the wrong file) and 2) if the correct file was selected I need to copy cells E10:E12 from Sheet1 of that file to cells E7:E9 of my workbook.
Thanks in advance for any help you can provide!
Jon