submit button and auto update for workbook?

[escelnewbie]

description of project: At work we have a workbook for vacation bids.
book 12 pages. Currently each day (356) has approx. 15 open slots eac
and approx. 350 employees. Currently all vacation bids are inpute
manualy and this becomes very time consuming considering each bi
requires input into 5 cells. So I am trying to reconstruct the book t
have a drop down list of names (easily done) with the shift they are on
and date range 1 day up to 2 weeks and click a "submit" button and boo
will automaticaly update. Is this possible with excel 10?
Currently we have initial bid a beginning of year (all 300 plu
employees) and a 'first come first serve' request thru out rest of year
(approx. 3-10 request a day) with 2 seperate shifts and worker
seperated from supervisors

 

[Auric__]

description of project: At work we have a workbook for vacation bids. 1
book 12 pages. Currently each day (356) has approx. 15 open slots each
and approx. 350 employees. Currently all vacation bids are inputed
manualy and this becomes very time consuming considering each bid
requires input into 5 cells. So I am trying to reconstruct the book to
have a drop down list of names (easily done) with the shift they are on,
and date range 1 day up to 2 weeks and click a "submit" button and book
will automaticaly update. Is this possible with excel 10?
Currently we have initial bid a beginning of year (all 300 plus
employees) and a 'first come first serve' request thru out rest of year.
(approx. 3-10 request a day) with 2 seperate shifts and workers
seperated from supervisors.

You might want to do a userform. Put dropdown above a calendar control, have
a slider control (or maybe a spinner) below that, and OK and Cancel buttons
below that.

+--------------+
| [ names ] |
| +----------+ |
| | calendar | |
| | calendar | |
| | calendar | |
| | calendar | |
| +----------+ |
| <--slider--> |
| [OK][Cancel] |
+--------------+

The dropdown would be the names as you said (loaded from wherever your
employee list is kept), the calendar would be the start date of the vacation,
the slider would be the vacation length, and OK would call the code to plug
in the data.