software

I have a number of worksheets for different users here at work, with a
master spreadsheet that I want their information parsed into. I'm
having trouble figuring out a function that can lookup their work based
on the quot;date worked onquot;. I'm fumbling with lookups trying to lookup by
date, then input all information to the right of the quot;date worked onquot;
column into the master worksheet. Having repeating dates has proven
difficult for me to figure out. For example, spreadsheet looks similar
to the below:

quot;date worked onquot; quot;base numberquot; quot;sales assisstantquot; quot;business areaquot;
2/11/06 12345 Mike G
GM
2/11/06 45678 Dan E GE
2/11/06 91011 Rich L GE
2/15/06 12131 Will A
GM
2/15/06 14151 Japar O
GE
2/19/06 38592 Eric E
GMThis would be one person's worksheet out of around 40 in the same
shared workbook. Would I be able to parse this information by date,
for each person in the workbook so that all information from 2/11/06,
for each person, would show up one after the other in the master sheet?
I'm suspecting I'm going to have to brush up on marcro's and get to
know them on an intimate level. If anyone can lend me their knowledge
it would be greatly appreciated.

By the way, anybody know of a good excel book/tutorial for the more
advanced functions and vba? Thanks in advance as always.

regards,
Spiro D--
spirosu
------------------------------------------------------------------------
spirosu's Profile: www.excelforum.com/member.php...foamp;userid=7442
View this thread: www.excelforum.com/showthread...hreadid=518003
Anyone? --
spirosu
------------------------------------------------------------------------
spirosu's Profile: www.excelforum.com/member.php...foamp;userid=7442
View this thread: www.excelforum.com/showthread...hreadid=518003