+ Reply to Thread
Results 1 to 2 of 2

same data from one cell copy to multiple sheets

  1. #1
    Leza
    Guest

    same data from one cell copy to multiple sheets

    I have 3 worksheet and I would like to have certain cell copy into a master
    sheet.
    So, when you enter a number into "sheet 1" in places it into "master" the
    cells are not in the same exact spot. Is there a formula to make these cells
    copy into mutiple sheets?

  2. #2
    C.S.Harris
    Guest

    RE: same data from one cell copy to multiple sheets

    Copy Master cell onto different sheets:
    Put this in the formula bar for the cell on each of the secondary sheets
    that will match the master. =Sheet1!C13 with C13 being your master cell.

    Use master sheet to add number value from different sheets:
    The master cell should read =SUM(Sheet2!C13,Sheet3!C10) with your
    secondary cells in place of C12 and C13.
    Sometimes Excel requires you to put in a $ in the formula.
    Hope this helps.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1