So I am stuck on how to get a desired output with the data I have and could use some help please. I have 3 Tables that I am working with for this situation.
The goal is to have all the IDs from table 2 to be populated number Column 2 (Firm ID) in table 1 (Summary). This is to give a list of each ID that is being tested. Next is to populate the columns after Firm ID with data from Pass/Fail.
Pass/Fail holds all the IDs that are missing a specific piece of data, denoted with “N/A”. If there is data present the cell would be “Y” and if it is N/A the cell would be “N”.
Is it possible to pull in this data from the different sheets into Summary using a loop?
Any help is appreciated!