• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. U

    Lock tabs from viewing

    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...
  2. U

    VBA code and data validation

    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...
  3. U

    Using names in a formula

    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.
  4. U

    vlookup formula won't update

    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?
Back
Top