In WS 2, I import data, including a key value in column D. In WS 1, I have a master list of data, including a key value in column D. I am trying to create a macro that does this:
For each key value in WS 2, column D:
- If key value exists in WS 1, column D
- Update columns E and F in row with matching ID
- If key value does not exist in WS 1, column D
- Add columns D through M for non-matching key to the next empty row in WS 1
I've tried to cobble together a macro based on snippets on this site, but am stuck on adding a new row. Any help is appreciated.