Sheet Filtering

LouisT

Board Regular
Joined
Apr 5, 2010
Messages
61
Hi Everyone, I'm trying to filter data from one tab to multiple tabs based on a specific value on Tab 1. In this case on a person's name. If the data in the row in question has a leader's name, then pull all that data in that row to the appropriate tab. There would be multiple columns to pull. I've thought of just using a Vlookup however i'm sure there's a more efficient formula.

any help would be appreciated.

Thanks in advance
LouisT
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,468
Members
409,883
Latest member
asharris90
Top