Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
spirosu
 
Posts: n/a
Default multiple worksheet lookup?


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 "date worked on". I'm fumbling with lookups trying to lookup by
date, then input all information to the right of the "date worked on"
column into the master worksheet. Having repeating dates has proven
difficult for me to figure out. For example, spreadsheet looks similar
to the below:

"date worked on" "base number" "sales assisstant" "business area"
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
GM


This 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: http://www.excelforum.com/member.php...fo&userid=7442
View this thread: http://www.excelforum.com/showthread...hreadid=518003

  #2   Report Post  
Posted to microsoft.public.excel.misc
spirosu
 
Posts: n/a
Default multiple worksheet lookup?


Anyone?


--
spirosu
------------------------------------------------------------------------
spirosu's Profile: http://www.excelforum.com/member.php...fo&userid=7442
View this thread: http://www.excelforum.com/showthread...hreadid=518003

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combine multiple excel file in to one excel file and multiple worksheet jbhoop Excel Discussion (Misc queries) 0 December 29th 05 05:59 PM
Serial Date in Multiple Worksheet John Excel Discussion (Misc queries) 10 December 29th 05 12:32 AM
Multiple criteria LOOKUP Leon Excel Worksheet Functions 2 December 22nd 05 02:13 PM
Converting multiple worksheet to a single page worksheet [email protected] Excel Discussion (Misc queries) 0 July 4th 05 06:26 PM
Multiple lookup value's rucker31 Excel Worksheet Functions 0 March 12th 05 12:17 AM


All times are GMT +1. The time now is 11:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"