Good evening all,
Please excuse my inexperience. I am trying to find a way to systematically go row by row on one worksheet, and for each ID, see below, add data to another worksheet in the row with a matching ID. Below is information on how my worksheets are setup.
Worksheet “10” data organized as follows:
A_________B_________C_________D_________E_________
123456______Doe________John_______10__________3.5________
654321______Jane________Doe_______12__________12_________
For each ID in Column 'A', I want to go to Worksheet “Data”, search for that ID (also in Column 'A'), if found add an “X” to Column 'E' on Worksheet “Data”. So for example, if Doe Jane was on Worksheet “10”, I would like Worksheet “Data” to reflect an 'X' for her in Column 'E'. Below is another example, John Doe was not given an 'X' because his ID was not found on Worksheet “10”.
Worksheet “Data” hoped to reflect this:
A_________B_________C_________D_________E_________
123456______Doe________John_______10__________ __________
654321______Jane________Doe_______12__________X__________
Worksheet “Data” will contain multiple entries with the same ID so I need to re-search row by row for each ID found on Worksheet “10”. I am hoping this is a simple enough task, but have little to no experience searching row by row and comparing to other worksheets and adding to found rows.
Any insight/guidance appreciated, thanks for taking the time to read this.
Regards,
Spencer
Please excuse my inexperience. I am trying to find a way to systematically go row by row on one worksheet, and for each ID, see below, add data to another worksheet in the row with a matching ID. Below is information on how my worksheets are setup.
Worksheet “10” data organized as follows:
A_________B_________C_________D_________E_________
123456______Doe________John_______10__________3.5________
654321______Jane________Doe_______12__________12_________
For each ID in Column 'A', I want to go to Worksheet “Data”, search for that ID (also in Column 'A'), if found add an “X” to Column 'E' on Worksheet “Data”. So for example, if Doe Jane was on Worksheet “10”, I would like Worksheet “Data” to reflect an 'X' for her in Column 'E'. Below is another example, John Doe was not given an 'X' because his ID was not found on Worksheet “10”.
Worksheet “Data” hoped to reflect this:
A_________B_________C_________D_________E_________
123456______Doe________John_______10__________ __________
654321______Jane________Doe_______12__________X__________
Worksheet “Data” will contain multiple entries with the same ID so I need to re-search row by row for each ID found on Worksheet “10”. I am hoping this is a simple enough task, but have little to no experience searching row by row and comparing to other worksheets and adding to found rows.
Any insight/guidance appreciated, thanks for taking the time to read this.
Regards,
Spencer