Hi, so I have a table of workers. Their names are in column A. Their trade is in column C.
I would like to have a named range for each trade. The thing is, if they change trade via drop-down, their name should show up in the corresponding named range. Thanks for your help. Hope it's clear enough.