Please can you help?
I would like to be able to pull across a whole line of data from a separate table to a new sheet if the data matches.
I.e. I want it to automatically pull anything with clinic to a new sheet so I can sort by grade order. Is this possible
If this is my data table
data.jpg
I want to automatically pull the CLINIC department across to a new sheet to create a table like this (where it will pull the data and I can add to it, but if the data in the original sheet changes it will automaticaly change my second sheet)
new table.jpg
Thanks
Bookmarks