Thank you for your reply! Here is a little more information regarding this
mess I've created!
Data Input tab:
Colum B (all the way down) is a drop down box of various auditors
Colum's C, D are also drop down options
Column E is last names of Team Memebers,Column F is First Names
Column G is Manager names and H is a drop down of Supervisors (I've set
colum H to only include names that are associated with the manager that is
selected in G)

Tab Jane Doe (auditor) (each auditor has it's own tab):
when jane goes to her tab and selects her name in the drop down in column B,
all the rows of information from Data Input tab that has her name in
DataInput colum b, comes across and she enters more information in various
columns for those Team Members.
What I want from janes (and all other auditors tabs) is when John Doe
Supervisor is selected, all the information on that same row be copied back
to John Doe tab.

Is this even possible?
Thanks again

"Bernard Liengme" wrote:

Use VLOOKUP in the form =VLOOKUP(A2,Sheet1!H2:M1000,2, false)
and =VLOOKUP(A2,Sheet1!H2:M1000,3, false) etc
Then use Data | Filter |Auto Filter with a custom filter of: Not Equal to
#N/A

I am assuming the data on sheet 1 begins in H and continues to the right
If this is not the case, we need a Match and Index combo - let me know how
Sheet1 is set out
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"bbrant2" wrote in message
...
I am trying to get information from one sheet to another. On sheet 1 I
have
a list of various names in Column H. I would like for sheet 2 to gather
the
row of information if the name in sheet 1 column H is equal to sheet 2 A2.
But i don't want blank rows (or ones that don't match) to come across on
sheet 2.
Can any one help with this?