I need some help creating a database for my spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help w/ spreadsheet needed 2
Excel spreadsheet to Word document 1
Find Specific Rows in Range and Create New Tab 18
code for Copying rows based on a value 2
Same spreadsheet used for multiple months 3
SaveAs file name 0
I need a Macro to extract data by customer to new worksheets 9
How to create a bubble chart with more than 2 variables 0

Back
Top