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
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.
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
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.
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.