Completed

Excel - Employee Schefule and Holiday Sheet -- 2

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.

Details

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

Excavator 1

Excavator 2

Bulldozer

Truck1

Truck2

Truck3

Truck4

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.

Skills: Data Processing, Excel, Visual Basic

See more: excel vba look data sheet, excel automatic copy database sheet, vba excel lock columns refreshing sheet, employee vacation planner template excel, employee vacation planner template excel 2018, free annual leave spreadsheet excel template, staff holiday planner 2018 excel, staff leave planner excel free download, staff holiday planner template free excel, employee absence schedule 2018, employee vacation tracker excel, excel estimated net seller sheet, mini project excel employee salary details, excel customer rating evaluation sheet, file employee leave excell sheet, excel create data entry sheet, excel employee transfer, excel autorefresh data entry sheet, employee vacation tracking sheet, excel vba update closed sheet

About the Employer:
( 1 review ) St.Ives, United Kingdom

Project ID: #18019646

Awarded to:

SBITServices

Hello Luke Rodgers , I have read your project description and i will design excel sheet as you required for maintain your Employees and Trucks. I have 5 years experience in Excel VBA programming and comp More

£60 GBP in 1 day
(388 Reviews)
7.3

30 freelancers are bidding on average £118 for this job

schoudhary1553

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid More

£150 GBP in 3 days
(292 Reviews)
7.7
paris2785

Hi, there! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to work on data validation more or less. All tasks you mention can be accomplished thro More

£140 GBP in 3 days
(166 Reviews)
6.8
prameswara

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

£100 GBP in 3 days
(322 Reviews)
7.0
Nawaz091993

Greetings! I am an Excel expert and have clearly understood your requirements that you need to safely assign an available employee on the day to the machine they can operate. You need this done so its easy for you usin More

£120 GBP in 2 days
(77 Reviews)
6.0
SShtv

I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have successful experience performing similar work. These are screenshots of some of my works. [login to view URL] More

£150 GBP in 3 days
(61 Reviews)
5.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. Will do it in excel itself. Willing to take up your project. Thank More

£150 GBP in 3 days
(64 Reviews)
5.6
asadkhan3533

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

£100 GBP in 3 days
(73 Reviews)
5.7
supper5guy

Hello there, as an expert in excel and VBA, i can help you to accurately create such a workbook with your necessary schedules and drop down and data validation as you have specified. Please contact me and let us talk More

£120 GBP in 3 days
(72 Reviews)
5.4
c4cuteconain

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.

£50 GBP in 3 days
(36 Reviews)
5.0
daniyal3214

I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform data analysis, financial analysis, database modeling, financial modeling, resource schedul More

£40 GBP in 1 day
(42 Reviews)
5.2
rIbrarahmed

hi, I am very good in data entry having good typing speed as well and also very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself More

£84 GBP in 1 day
(15 Reviews)
3.8
dataexplorer

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor More

£20 GBP in 3 days
(14 Reviews)
3.4
paulodayto08

Hi Good Day! A serious freelancer here! I can help you to complete this work in 1 day. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to co More

£50 GBP in 1 day
(15 Reviews)
3.4
krishnaagr89

Hi,I have read your requirements of Excel - Employee Schefule and Holiday Sheet -- 2 and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to More

£144 GBP in 4 days
(4 Reviews)
3.0
abdelrahman1987

i am a civil engineer, with an excellent experience in your requirements. Quality and time are respected strictly Regards,

£50 GBP in 3 days
(3 Reviews)
2.2
rhbasas

Hi, I can do what you ask. I can send you sample if you want to. The price is also negotiable. I think I have a better idea for the 2nd part 3 ( The one with the holidays and stuff). Just message me and I will prepare More

£222 GBP in 7 days
(1 Review)
0.6
easma

To design an MS-Access relational database using your sheets as Access tables and joined by Employee 3 or 4 tables. To create 3 or 4 data input forms which can export to excel files with a touch of a button. The last f More

£277 GBP in 15 days
(0 Reviews)
0.0
fnssadiya

Hi, I am excited to see this project as I am an excel expert and I also worked in the trucking industry generating excel sheets and KPI's for them. Its a very suitable project for me. Please let me know if you are i More

£155 GBP in 3 days
(0 Reviews)
0.0
billpinder82

Good evening, my name is William Pinder. I am an Excel expert with 10 years of professional experience. I run a web development and Excel consulting service in Canada. I have read your job description and I can build More

£150 GBP in 3 days
(1 Review)
0.0
informatikz

Hi, we are qualified Management Accountants (ACMA & CPA members) working in Australia. Please look into our LinkedIn profiles mentioned in the freelancer profile for more details. Following is my profile. https://ww More

£23 GBP in 2 days
(1 Review)
0.0