Cross sheet consolidation

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

Right I have a great big table in sheet1, it is a list of projects and the region they're in.
I want to create a formula in sheet2 that is going to look for a particular region, eg Europe, and then copy the entire row for each instance fo Europe into sheet2.
Is this possible, and if so, how?

Kindest regards and grateful thanks

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
autofilter for Europe and copy visible cells to another sheet.