In Progress

Create a set of excel templates

I am looking for someone who is an expert in Microsoft Excel. With work I have designed a set of spreadsheet concepts I want to happen, I just don't know how to actually make it happen.

The idea is that data would go into 1 certain spreadsheet on a daily basis for the days activity from all of the staff (Annexure 1) This would have the number of cars washed and number of car washing products sold for each staff member for each day over a 2 week period. As a result of entering that data each staff would then have 3 other spreadsheets that would automatically update, 1 being a summary of their activity over this period, 1 being an invoice for car washes done and the other being an invoice for car washing products sold - these would be produced at the end of the 2 week period.

The Annexure 1 spreadsheet could see up to 100 staff members listed, with each week new staff being added to the list (and as such we would need the other 3 spreadsheets automatically being added and updated)

I want to be able to edit the headings of the rows and columns as I will duplicate the excel file

Skills: Excel

See more: microsoft excel spreadsheet, microsoft excel 2013 expert, looking for duplicate data in excel, expert in microsoft excel, microsoft spreadsheets, excel expert 2013, spreadsheet microsoft excel, excel templates, excel duplicate, create invoice, create a excel, car excel data, create member, activity spreadsheet, excel 2013 expert, 100 templates, excel file columns, microsoft excel 2013, excel list update, excel edit, excel create list, spreadsheet templates, car data file, staff excel, car excel list

About the Employer:
( 8 reviews ) Wollongong, Australia

Project ID: #4730036

Awarded to:

satsin7

Hello Interesting project. Will be glad to discuss this over. I have developed many utilities in Excel.

$20 USD / hour
(23 Reviews)
5.2

9 freelancers are bidding on average $19/hour for this job

hegemon88

Excel is my middle name

$29 USD / hour
(4 Reviews)
3.4
JScottArnold

Good afternoon! I am an Excel guru with years of experience developing tools and spreadsheets for a variety of clients. I'd be happy to talk with you more about your project and what I can do for you.

$22 USD / hour
(1 Review)
2.9
jonaal

hi, i make these kind of excel sheets every day.

$11 USD / hour
(2 Reviews)
2.1
mgreenwell

I am an advanced excel user and am ready to deliver.

$22 USD / hour
(0 Reviews)
0.0
KG32

I have experience in Excel databases. Please refer to PM for details.

$16 USD / hour
(0 Reviews)
0.0
tmoore562

Linked worksheets. Can do. “..up to 100 staff members”. A drop down list of staff members would make data entry easy so that would be my suggestion here. Please see the private message for the potential problems.

$15 USD / hour
(0 Reviews)
0.0
absrads

Have seen sooo many fake projects and I hope this one isn't. If you are seriously looking for a solution to what you have posted here, pls refer to my PM... Thx.

$15 USD / hour
(0 Reviews)
0.0
manojsonowal

Your Project is complete as per your project description. I had also made some automations for your ease of operations. See your Private Message for more info

$20 USD / hour
(0 Reviews)
0.0