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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,292
Messages
5,836,448
Members
430,431
Latest member
Tomexcel2022

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