J
JR
I am trying to populate "Column E" in "Tab_1" with data from "Tab_2".
These are two tabs in the spreadsheet.
Tab_1:
- Column C, has a value say 12345a.
- Column E is blank.
Tab_2:
- Column A has a list which contains 12345a
- Column B has another value, one for each item in Column A
I want Column E in Tab_1 to be populated with the value in Tab_2
Column B where Tab_1:Column C matches Tab_2:Column A. There will be
only one match as each value in Tab_2 Column A is unique. Was
thinking a Macro could be pasted down Column E in Tab_1 to facilitate
this, but wasn't sure how to code it. Any suggestions?
Thanks.
JR
These are two tabs in the spreadsheet.
Tab_1:
- Column C, has a value say 12345a.
- Column E is blank.
Tab_2:
- Column A has a list which contains 12345a
- Column B has another value, one for each item in Column A
I want Column E in Tab_1 to be populated with the value in Tab_2
Column B where Tab_1:Column C matches Tab_2:Column A. There will be
only one match as each value in Tab_2 Column A is unique. Was
thinking a Macro could be pasted down Column E in Tab_1 to facilitate
this, but wasn't sure how to code it. Any suggestions?
Thanks.
JR