I have a spread sheet that I use to track time spent on projects.
My 1st column is the job name or number. My file contains 13 worksheets
One for each month and then a overall summary. When I go to type in the job
name
it will automatically fill in the blank if the job name has already been
type in that column before. Now when I move to the next months worksheet I
have start over again with the job names. Is there a way I can have this 1st
column read from another worksheet So that it searches that sheet and once I
start typing in a name it will auto fill?

Why wouldnt you use ONLY ONE spreadsheet to record all your data an
then use autofilter to show the months? Anytime you can keep all you
data together it is a really good idea. From there you can do almos
anything you would do with separate sheets

--
Excelenato

-----------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...fo&userid=3676
View this thread: http://www.excelforum.com/showthread.php?threadid=56532