Sorry this is a repost as i needed to change the details. This is very much a job for someone who is an Excel expert with experience in complex data validatiin drop down list construction.
I know that this might also be a job for Microsoft Access which will be fine as long as I can get excel outputs with specific colouring and layout which can be interrogated by excel without having to export from access.
I work for a company that employs machinery operators. I need an excel file that contains the following ...
A sheet with all employee details including which of the 6 machine types they can use ( this could be one or many) ie...
Name phone excavator dozer truck
J blogs 12345 yes yes no
I then need a spreadsheet with all the employees holidays on a daily basis for the whole year.
This is the complex bit... I then need a schedule sheet with days of the year across the top and list of machines down the side by type ie...
Day 1 2 3 4 5
I need data calidation in the cells on this schedule table to show a drop-down list of operators in each cell which can operate that machine and are not on holiday on that day so in effect the cell list is being created from the holiday sheet and the staff details sheet. This is quite complex and I'm not sure if it can be done in the data validation alone.
30 freelancers are bidding on average £118 for this job
Hello Sir im excel VBA macro and formula Expert :) i can make build your schedule and holiday sheet please ping me for discuss detail Sir Thank You Sincerely Galih AP
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.