Previous Topic Next Topic

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

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.
0

Similar discussions

Excel VBA Format a Range Borders to Crossed diagonal lines
mathewmunna -
MaxStart -

4 responses