I am new to the forum and tried to find what i was looking for prior to posting but could only find posts that were similar but not quite what I needed. So here goes.
I have a list of investors on my Master sheet, and I need to create a list based on the responses in Column B-E. I have attached an example sheet. I need the investor number to be included on a list on the appropriate sheet.
ex:
Investor HAM PRA UP HAFA
00064 no yes no input no
I need investor #00064 to go to 4 corresponding sheets, HAM NO, PRA YES, UP UNKNOWN, and HAFA NO.
I do not want the investor number to be removed from the Master sheet.
Bookmarks