1 form enter certain data on certain sheets

[airborne4905]

I have a workbook with 15 different sheets. Each sheet has a different job name in cell A1 after that everything is identical except for the tab name which is the job number example "TN964" . I want to create a form that will put all the information I enter into ONLY the JOB sheet that would correspond with the job# entered. I enter the information manually on each sheet and have to click back and forth which gets confusing sometimes and I end up putting the wrong info on the wrong sheet.

The info that I have to enter is

Employee Name
Date
Time spent on Fabrication
Time spent on Travel
Time spent on Loading / Unloading

I know I would also have to enter the JOB# in the form so that it will know which sheet to input the information too.

I'm not sure where to really start. Please help!

 

[lenze]

Hi and welcome to the board!!
You really should consider having only ONE sheet with "Columns"
Job#---Date---Activity---Time.
Much better for Data Analysis. It is seldom correct to have multi-sheets when there is only ONE difference (Job#).
There is a reason Excel gives you 65536 Rows and Only 216 Columns!(More in 2007)
lenze

 

[airborne4905]

We have to keep up with several employees for each job # and at the end of the week we have to print each job separately because they are sent to different companies.

 

[lenze]

We have to keep up with several employees for each job # and at the end of the week we have to print each job separately because they are sent to different companies.

SO!!!
The format I suggest will allow you to do that. (You may need to add an Employee column). In fact, Excel was designed to analyze data in that format!! All you have to do is take advantage of the Built-in "Data Analysis" tools in Excel. Things like Pivot Tables, Advanced Filter, DFUNCTIONS, MSQuery.

lenze