I have an excel sheet with row 1 depicting employee training options.
Column A depicts the employee IDs. If they have selected that option there is a Y in the relevant cell.
On another sheet, I'm trying to return the employee IDs for each option.
So far, i've been attempting to use if statements, for example:
If option1 = "y"
then sheet2.cells(2,1).value = option1.offset(0,-1).value
I'm trying to list the employee IDs.
I'm struggling to cycle through column B until the employee IDs run out, skipping blank cells.
Any guidance would be really helpful, I'm thinking I need to add a loop?
Let me know if there's any other information I can provide as I'm new to the forum!
Thanks in advance!