Excel

[fitz68]

I have a file that has a master tab with all the information I need. I would like to have other sub tabs that only display certain data from that master tab. For example the master tab would look something like this(with 3 columns):

A B C

Sean11 12 44CC

Jason12 14 87CC

Derrick13 34 22DR

Jason13 44 23BB

Jeff11 67 23F

Derrick15 87 54VBG

Jason21 26 23SE

Sean13 34 11DRE

Derrick21 44 45FEW


There would be 4 different tabs labeled Sean, Jason, Derrick and Jeff. I would like to use a formula in each sub tabs, where each tab automatically updates based off the information I enter in the master tab. So the Sean Tab would look like this:

A B C

Sean11 12 44CC

Sean13 34 11DRE


Vlookup doesn't quite work because it only looks at the first value and there are numbers attached to the names. Any help would be very appreciated, Thanks!!!

 

[Hui]

Fitz68


Firstly, Welcome to the Chandoo.org Forums


Have a read of http://chandoo.org/forums/topic/move-items-matching-certain-filter-criteria-to-another-sheet

or

http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/

 

[DonMinter]

Just an aside, Fitz, but you should pick a title that lets folks know a bit about your question. "Excel" doesn't really tell us anything, as this is an Excel-centric forum.


Don

 

[fitz68]

Thanks for the help! Sorry about the title, my first time posting.