Hi,
I am attempting to filter a list depending on a list in a different spreadsheet. The master list the one that has each variable while the filtered list has multiple entries for each different variable and I need to seperate each variable so that I can copy it to the tab with the title found on the master list.
I was hoping that I could use a shifting filter to be able to do this but I don't know how and if it isn't possible does anyone have a different idea? I may be too focused in the wrong direction and the codeI currently have wouldn't be useful in this so...
I could really use some help!
Thank you!
I am attempting to filter a list depending on a list in a different spreadsheet. The master list the one that has each variable while the filtered list has multiple entries for each different variable and I need to seperate each variable so that I can copy it to the tab with the title found on the master list.
I was hoping that I could use a shifting filter to be able to do this but I don't know how and if it isn't possible does anyone have a different idea? I may be too focused in the wrong direction and the codeI currently have wouldn't be useful in this so...
I could really use some help!
Thank you!