Hi.
We are using excel to keep track of work hours on a third party call centre (selling subscriptions on behalf of publishers and media corporations, newspapers aso). Each employee must sell services for a certain amount before they start earning bonus per sale. Workhours and sales below the threshold are registered in e.g column C5-C16 and D5-D16, whereas workhours and sales above threshold are registered in cells E5-E16 and F5-F16. All billable hours and sales are kept track of in the spreadsheet (one per employee) and summarized at the bottom. Bonus per sale kicks in when they reach a turnover of lets say 40k. The challenge is: I would like to keep but C5-C16 and D5-D16 locked as long as they work below threshold, and as soon as they reach 40k turnover, all but E5-E16 and f5-F16 should be locked... is that possible? Anyone who knows how?
Current practise is to keep separate spreadsheets per employee below and above threshold... manual labour....