Hi,
I am looking to create a macro that will search 1 spreadsheet named input under column/rows b and match another spreadsheet called output on another file in column/rows i. If it matches then on input column/rows to grab the contents in cell d and I on the same row as the match and then copy/replace cell to output on the same row as the match to column j & k.
I have attached a spreadsheet called Input and Output and on Output will have another tab called Results Example. I highlighted the search and match columns in yellow for Input & Output. I then highlighted in Red if the search & match columns match to replace the cells.
The Tab on Output called Results Example I have what the final results should look like. The columns that are changed should be blue.
Note: The Results Example tab is just an example not where I want it stored. The Results should be replacing column/rows on the output tab on j & k.
Explaining it is difficult but I hope my spreadsheet examples helped out.
Thanks for your help in advance
Input.xlsxOutput.xlsx
Bookmarks