Combining Data to One Sheet

[calming.insanity]

hello,
I am kinda stuck on this one.
I have 2 sheets that have data
one has data with these headings
WE Date Date Name Staff Time

and another that has this data:

Copy of M50 Scorecardblanked.xls
	B	C	D	E	F	G	H	I	J
1	WEDATE	StaffTime	LawsonID	Name	LastName	FirstName	StartDate	Coach	Date
2	5/12/2007		555555	Last,First1	Last	First	1/23/2006	CoachName	5/10/2007
3	5/12/2007		555555	Last,First2	Last	First	9/3/2002	CoachName	5/11/2007
4	5/12/2007		555555	Last,First3	Last	First	9/16/2002	CoachName	5/11/2007
Agent Trade Data

i need to put the data from the sheet that has staff time into the 2nd sheet. there will be multiple we dates, names, dates. I have been doing this through a vlookup on the date range for the staff time, but that is extremely time consuming. Any ideas on a formula that will do this for me?

 

[TTom]

Have you considered doing this in VBA macro? There is a point where it excels (pardon the pun) over formulas.

Do you need conditionals? IF condition Then transfer data to Sheet2?

 

[calming.insanity]

hmmm

i don't even know where to begin as these lists aren't organized the same way(the names might be out of order). i have considered a loop to check wether the name matches and if it does, put the staff time. but not sure.