Cross sheet consolidation

Closed

Exhell - 1 Dec 2009 à 10:36
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 1 Dec 2009 à 19:19

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
How to copy data from one excel sheet to another - Guide
Google sheet download - Download - Spreadsheets
Vba add sheet - Guide
Windows network commands cheat sheet - Guide

1 response

Réponse 1 / 1

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

autofilter for Europe and copy visible cells to another sheet.

Similar discussions

Copying data from one Excel sheet to another.

Data Consolidation

Extract data from one sheet to another

Similar discussions

Subscribe To Our Newsletter!