Combining Data to One Sheet

calming.insanity

New Member
Joined
Apr 27, 2007
Messages
22
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
BCDEFGHIJ
1WEDATEStaffTimeLawsonIDNameLastNameFirstNameStartDateCoachDate
25/12/2007555555Last,First1LastFirst1/23/2006CoachName5/10/2007
35/12/2007555555Last,First2LastFirst9/3/2002CoachName5/11/2007
45/12/2007555555Last,First3LastFirst9/16/2002CoachName5/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?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

TTom

Well-known Member
Joined
Jan 19, 2005
Messages
518
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

New Member
Joined
Apr 27, 2007
Messages
22
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,174
Members
417,130
Latest member
Darion2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top