submit button and auto update for workbook?
 

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.

submit button and auto update for workbook?
 

escelnewbie wrote:

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.

--
"Tomorrow" is just another word.