How to pull a UID to a seperate sheet based on criteria?

Steve Cribbs

Hello,

I have a form that feeds into a master list and auto-generates a UID. I'd like to pull all UID's for a team, as identified by the column "Program Alignment" within the master list, into a separate sheet for each team so that I can Data Mesh off of that UID.

Thanks for the help!

Steve

Paul H

Possibly a Copy Row Automation with multiple condition paths based on each team.

If you have Data Shuttle you could also offload the master, then upload back to each individual team sheet

Steve Cribbs

I think Copy Row Automation might be my answer but I'm getting the following error.

Paul H

Make sure you don't have an auto number column on your destination sheet, even easier start with a blank fresh grid and let the first "Copy Row" execution add all your columns for you