Hello All
I know most of the basic uses of excel, probably heading into the intermediate category of user.
I didnt do a search, because I dont know what exactly I need to search for to gain my result I am looking for, so sorry in advance if it turns out to have been covered elsewhere.
What I have in the attachment is a spreadsheet recording holiday for drivers who work for me. In the 'Drivers Tab', the layout is split as I will be using this spreadsheet in Excel 2003 which runs out of columns, as apposed to me using 2007 to make it. In the 'Drivers' Tab, I have a list of Drivers, their holiday entitlement for the year, with formulas working out how much is booked and unbooked. Then I have conditional formatting as you can see in the columns, green cells to highlight the hours booked, and red columns if there are more than 2 drivers booking the same day off.
In the 'Individual Colleague Printout', this is a slimed down version which really is for reference to the colleagues if they request a printout of their annual holiday. The main black box up the top uses Data Validation drop down menu to get a list of the drivers from the 'Drivers' tab. And then basically in the actual content itself, uses vlookup to get the results if the colleague has booked that day off. It will be easy to see what I have done when you open up the spreadsheet itself.
Now, onto the main point of me posting this thread. Basically when a colleague hands a holiday form into me, I input the data into the 'Drivers' tab. What I was wondering, would it be possible for me to enter the data into the Individual Colleague Printout tab itself, and then automatically publish into the Drivers tab? And if I select another driver from the black drop down list, for me to do the same and it keep presenting the data for the driver selected, aswell as inputting into the drivers tab?
Any help will be fantastic! Many thanks in advance!
Ash
Bookmarks