Hello!
I have two different spreadsheets.
On Spreadsheet 1, I have subset of data in column A and I need descriptions to populate in column B that match that subset.
On Spreadsheet 2, I have a set of data in column C and matching descriptions in column D.
What I want to do is, open only spreadsheet 1, manually and then have VBA open spreadsheet 2 and execute the following vlookup formula from column B of spreadsheet 1: "=Vlookup(A1,'[Title I provide]!'$C:$D,2,false)"
After that I know I can record a macro that copies and pastes as values but I don't know how to have VBA prompt me to open the second file and continue to execute thereafter.
If anyone can help, it would save me hours of manual manipulation.
Thanks,
epixjcp
I have two different spreadsheets.
On Spreadsheet 1, I have subset of data in column A and I need descriptions to populate in column B that match that subset.
On Spreadsheet 2, I have a set of data in column C and matching descriptions in column D.
What I want to do is, open only spreadsheet 1, manually and then have VBA open spreadsheet 2 and execute the following vlookup formula from column B of spreadsheet 1: "=Vlookup(A1,'[Title I provide]!'$C:$D,2,false)"
After that I know I can record a macro that copies and pastes as values but I don't know how to have VBA prompt me to open the second file and continue to execute thereafter.
If anyone can help, it would save me hours of manual manipulation.
Thanks,
epixjcp
