+ Reply to Thread
Results 1 to 5 of 5

Replicate from one sheet to another

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    Replicate from one sheet to another

    I have a similar problem. Not exactly the same though:

    I have a table in one worksheet 1. I need to replicate a same table in worksheet 2 but in a way that if I make changes in worksheet 1 the same change is automatically made in the replica table on worksheet 2.

    Any ideas??
    Last edited by JBeaucaire; 10-31-2012 at 02:51 PM. Reason: Moved to a thread of its own, as per forum rules.

  2. #2
    Registered User
    Join Date
    10-29-2012
    Location
    Burlington, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Replicate from one sheet to another

    Wouldn't you click on the same cell on the 2nd sheet, hit "=", click on the 1st first and click the same cell and hit enter? It would reference that cell from the first sheet.

    TLDR;
    you want A1 to be the same on both sheets...
    go to sheet 2 A1 and hit "="
    goto sheet 1 A1 click on it and press Enter.

  3. #3
    Registered User
    Join Date
    10-23-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Replicate from one sheet to another

    yeah, but i have an entire (fat ***) table on sheet 1 (20 columns and 50 rows and increasing). it'll take me forever to do this. on top everytime there is an addition on Table 1 (sheet 1) i'll have to redo the "=" to thing on more then 20 columns.

  4. #4
    Registered User
    Join Date
    10-29-2012
    Location
    Burlington, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Replicate from one sheet to another

    true. you can drag the formula once entered accross then entire page anticipating additional rows/columns. The values will simply show as zero's.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-23-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Replicate from one sheet to another

    Thanks! that did the trick!

    Appreciate it

+ 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