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

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

Cross sheet consolidation
Little alchemy cheat sheet - Guide
Google sheet right to left - Guide
Cmd network commands cheat sheet - Guide
How to screenshot excel sheet - Guide
Mark sheet in excel - Guide

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 1, 2009 at 07:19 PM

autofilter for Europe and copy visible cells to another sheet.

Subscribe To Our Newsletter!