+ Reply to Thread
Results 1 to 4 of 4

Linked Worksheets auto insert rows

  1. #1
    Registered User
    Join Date
    06-05-2009
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel 2003
    Posts
    4

    Linked Worksheets auto insert rows

    If data in Sheet2 is linked to Sheet1
    Example:
    Sheet1
    .......A.........B.........C
    1 ..Data....Data.....Data
    2 ..Data....Data....Data

    Sheet2
    .............A...............B..............C
    1 =Sheet1!A1 =Sheet1!B1 =Sheet1!C1
    2 =Sheet1!A2 =Sheet1!B2 =Sheet1!C2

    How do I insert a new Row 2 in Sheet1, that would automatically insert into Sheet2 in the same location and have the same formulas as the row above so that any data entered on Sheet1 also is filtered down into Sheet2?

    Thanks!
    Last edited by JohnHagan1; 01-15-2013 at 12:31 PM. Reason: Columns headings did not line up with example data

  2. #2
    Registered User
    Join Date
    02-04-2013
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Linked Worksheets auto insert rows

    Hi

    Open your workbook, select sheet1, now press the Ctrl key and hold down now click on sheet2 release Ctrl key. highlight row 2, click on insert new row. switch to sheet2, copy formulas in row 1 into new row 2. switch to sheet1, enter some test data...switch to sheet 2 test data should be present.

    hope this helps

  3. #3
    Registered User
    Join Date
    06-05-2009
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Linked Worksheets auto insert rows

    Thanks! Not exactly the answer i was hoping for but definatley works.

  4. #4
    Registered User
    Join Date
    02-04-2013
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Linked Worksheets auto insert rows

    Hi

    You could always record a macro, than add the macro to either the worksheet or the ribbon

+ 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