Creating a 'Access-like' input form

[mckenny16]

Hi to all,

Excelforums newbie here, needing some help with a job I've been given.
I'm usually a Access person, but Excel seems the better option wit
this. I need to create workbook that will show the jobs numbers/name
with which employee has worked on it, which date and how much time ha
been spent on it. Basically, each sheet will have on job on it, wit
the dates of the year (yeah, he want every working date of the year o
one sheet) along the y axis and employee names along the x axis
therefore having the amount of time spent on this project in th
corresponding field.

However, after building the input form on Access, the boss want
something similar, but I'll need to do it in Excel. So, I need t
create a input form that will have combo boxes (I can do these) fo
employee names, job number, and date, with an input box for time spent
I need the time spent to be magically placed into the exact field
need it to be. Any help on this would be really appricated.

Mat

 

[Guest]

hi.
Use job number in the form to select the sheet.
use date in the form to select the date
everything else would be offset right from the date