Hello all I am new to this forum and have never posted to any EXCEL forum before.

I have a workbook I am working on that is going to be over my head for what I want it to do.

I attached a sample of what I am trying to do for reference.

Here is what I am wanting this workbook to accomplish:

I need to be able to update the master sheet with all new sales info that will then automatically update the corresponding sheets for each employee.

This update will require adding new rows and/or columns every day that will automatically be added to the corresponding employee sheet and total.

The next step with these sheets is to have the commission increase at different total sales amounts so basically the more you sell the higher your commission.

I also want to be able to lock employees out of the master sheet and other employee sheets so they cannot view others commissions but can view or modify their own sheet.

I am extremely new to Macros to the point I don't even know how to create one so please treat me as a beginner if you go that route.


Thank you in advance for your help!

Sales and commission tracker.xlsx