Cross sheet consolidation
Closed
Exhell
-
Dec 1, 2009 at 10:36 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 1, 2009 at 07:19 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 1, 2009 at 07:19 PM
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
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
Related:
- Cross sheet consolidation
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- Elden ring cross platform - Guide
- Mark sheet in excel - Guide
- Little alchemy cheat sheet - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 1, 2009 at 07:19 PM
Dec 1, 2009 at 07:19 PM
autofilter for Europe and copy visible cells to another sheet.