(Sample Workbook uploaded)
Hi,
I need to fill in the empty cells in Column P (sheet1). This value(s) is to be found in Sheet2 Column A.
The procedure for the macro:
- Run only for empty cells in Sheet1 Column P (skips cells with data)
- Compare the data in the 3 columns in Sheet1 (E, F and H) with the data in the 3 Columns of Sheet2 (E,H, and F) respectively.
- If all the 3 columns match each other then copy the value from the respective cell in Column A Sheet2 and paste it to the respective cell in Column P Sheet1.
- In case of multiple matches, all the matching values found in Column A Sheet2 should be pasted in Column P Sheet1.
I hope you can help me with this. Either via VB Code (macro) or an Excel procedure.
Thank You,
JN
Bookmarks