You have chosen to sponsor your bid up to a maximum amount of .
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