Excel document
Budget: $1,500 – $3,000 AUD
Description of works needed
1. Lock cells certain cells so only admin staff can change them
2. Automatically pick up the colours of Damien, Dominic and Tony when they add painters to days (red, blue, green)
3. Need to be able to select and deselect names……currently we have to delete all the names in each cell and re add)
4. Names once chosen not to be able to be selected again on the same day,,, including on workers off section.
5. If not invoiced is selected its highlighted in yellow automatically
6. The amount of employees on each daily totals down the bottom “Total Painters”
7. Job number to automatically infill if put in next month
8. Calendar to automatically fill the correct days and month years etc.
9. Column Hight and width to suit text
Results PAGE separate ( I have attached a document we have now called Job register and we would like the results similar to that, however with info pulled directly from our JOB BOARDS, and all the results below
• Genre
• Supervisor
• Estimator
• Days allowed
• Variations
• Cost of sales
• Days taken
• Days under
• Days over
• Invoiced amount ( we will manually add and need that to reflect in the totals)
• Each job number even if on different months should tally these results as it goes on.
1. Lock cells certain cells so only admin staff can change them
2. Automatically pick up the colours of Damien, Dominic and Tony when they add painters to days (red, blue, green)
3. Need to be able to select and deselect names……currently we have to delete all the names in each cell and re add)
4. Names once chosen not to be able to be selected again on the same day,,, including on workers off section.
5. If not invoiced is selected its highlighted in yellow automatically
6. The amount of employees on each daily totals down the bottom “Total Painters”
7. Job number to automatically infill if put in next month
8. Calendar to automatically fill the correct days and month years etc.
9. Column Hight and width to suit text
Results PAGE separate ( I have attached a document we have now called Job register and we would like the results similar to that, however with info pulled directly from our JOB BOARDS, and all the results below
• Genre
• Supervisor
• Estimator
• Days allowed
• Variations
• Cost of sales
• Days taken
• Days under
• Days over
• Invoiced amount ( we will manually add and need that to reflect in the totals)
• Each job number even if on different months should tally these results as it goes on.
Related categories:
Excel Macros