+ Reply to Thread
Results 1 to 3 of 3

macro add new row to reflect the change in master sheet

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    81

    macro add new row to reflect the change in master sheet

    Hello there

    I need a macro to add a row at the same location on 'Interface Control' sheet when a new row is added to 'Master sheet' without disturbing the references or formulas on the 'Interface Control' sheet.

    Is there a way to do this.

    Please see attached the document for ref.

    Thanks in anticipation
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-11-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    81

    Re: macro add new row to reflect the change in master sheet

    Please can anyone advice on the above please....

    THanks

  3. #3
    Registered User
    Join Date
    09-11-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    81

    Re: macro add new row to reflect the change in master sheet

    I tried the below code to trap the line where an insert or delete row happened where it perfectly displays a msg box showing the row insert or delete is done. Now I want to copy the data on the row inserted or changed and paste it in the exact same location on 'Interface Control' sheet. Please can anyone help with this.

    on ThisWorkbook:

    Please Login or Register  to view this content.
    on Master Sheet:

    Please Login or Register  to view this content.
    on Module1:

    Please Login or Register  to view this content.

+ 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