Hi All,
I am needing help creating a macro because I am very new to all of this. The concept is trying to find part numbers associated with document numbers and once the part number is used to cross it out.
I need the macro to compare columns A & F on sheet 2 with columns E, G and H on Sheet 1. If A or F matches on Sheet 2 with E, G, or H on Sheet 1, then I need the text in column C Sheet 1 to be entered on Column E Sheet 2. I need the output to return all matches in one cell so if two part numbers match with one document, I need it to look like "PT1234, PT2345" in Sheet 2 in one cell. Also once the part number is used in sheet 2, I need it to be crossed out on Sheet 1.
Can anyone help? I am desperate and have no clue how to start this! I have attached the spreadsheet I am working on. Thanks for your help!!!
Bookmarks