+ Reply to Thread
Results 1 to 2 of 2

Replicate the Insert Rows action in a second worksheet, automatically

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    49

    Replicate the Insert Rows action in a second worksheet, automatically

    One more for today:
    I have a workbook with two worksheets, both having similar data in the columns.
    I want to set this up so that if I insert new rows into Sheet1 they are also insterted automatically into Sheet2 in the same place.
    The rest of the sheets will have formulas and calculations but for simplicity they are not included on the attached book.

    I hope to set up a quite large workbook and several people would use it, so ideally I'd like this to happen without the user knowing it. I think if it was a macro, they would need to perform an action to run the macro - but that's not what I'm after.

    Is there a way to do this?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-08-2012
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Replicate the Insert Rows action in a second worksheet, automatically

    A macro is usually associated with a push of a button or a keyboard shortcut. However vba code can be set up so it gets triggered by a certain type of event. I am not sure if inserting a row is such a triggering event, but maybe someone on the vba forum can help?

    Not sure how to move the thread... Anyone?

    -nise23

+ 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