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.