General discussion

  • Creator
    Topic
  • #2296702

    Excel

    Locked

    by jt1576 ·

    I have an excel spreadsheet that has our site inventory in separate worksheet tabs (with each site’s name) and one worksheet that has all of the inventory in it from the individual site tabs. My question is, is there a formula that I can use whenever I make a change in the master worksheet, so it will make the change in the approiapite site worksheet? or would it be too much of a headache to use the formula (if there is one)

All Comments

  • Author
    Replies
    • #2673616

      Reply To: Excel

      by sheryl v ·

      In reply to Excel

      Try Vlookup.

      If the cell is the same (EX:A3) on every the, then you just have highlight all the worksheet tabs you want to change before making the change.

    • #2673586

      Reply To: Excel

      by dklippert ·

      In reply to Excel

      Sheryl V is right. Hold down the Ctrl key and click on the appropriate worksheet tabs.
      On the Title bar you’ll see [Group].
      What ever is done to one page will be dupicated on the others in the group.

    • #2670555

      Reply To: Excel

      by richtee ·

      In reply to Excel

      If you are making anything other format changes the simple answer to your first question is NO.

      You can only affectively make FORMAT changes when selecting the ‘site’ worksheets AND the ‘Master’ worksheet.

      FORMULA changes can be made for multiple ‘Site’ worksheets using the above answers.

      However, the ‘Master’ worksheet will have roll-up formulas that may, or may not, have to be changed depending on the changes that are made in the ‘site’ worksheets and how they will effect the master. Changes in the ‘Master’ will not change the formulas in the ‘site’ worksheets.

      More information regarding the ‘changes’ to be made would be needed to discuss further.

      Rich

      • #2671975

        Reply To: Excel

        by jt1576 ·

        In reply to Reply To: Excel

        Poster rated this answer.

    • #2671974

      Reply To: Excel

      by jt1576 ·

      In reply to Excel

      This question was closed by the author

Viewing 3 reply threads