I am running commissions for our five sales reps. I am creating an excel file where I will track their progress. I'd like to do this in one excel file with five tabs, one for each sales rep. I'd like to password protect each tab with a unique password so that to view the tab, you have to have...
In cell A1 I have data validation that only allows a list of 1, 2, or 3. In cell D1, I have data validation that only allows a list of A, B, or C. I need to keep a user from selecting 1 in cell A1 and C in cell D1. I cannot figure out how to keep a user from selecting this combination. Is...
I have created a formula that references a cell on another tab and after the formula was created, named the cell on the other tab. Is there a quick way to update my formula to list the name, not the cell on the other tab? Thank you for your help.
I have a vlookup in book 1 that references a list of values in book 2. When the numbers in the list in book 2 are updated, the vlookup in book 1 does not update. Do you know how I can address this?