Please tell me to go away if you like.
I have a table full of names (starting at B3 to H3), column A has which sites to work at.
I need to 'transfer' the data in columns D to H from this table to another sheet depending on the site in column A
I think this is a VLookup or a filter formula but neither of these works.
Any guidance would be much appreciated
Regards
Matthew
I have a table full of names (starting at B3 to H3), column A has which sites to work at.
I need to 'transfer' the data in columns D to H from this table to another sheet depending on the site in column A
I think this is a VLookup or a filter formula but neither of these works.
Any guidance would be much appreciated
Regards
Matthew