+ Reply to Thread
Results 1 to 6 of 6

Automatically delete corresponding row after deleting a row from the master sheet

  1. #1
    Registered User
    Join Date
    03-08-2014
    Location
    Kolkata
    MS-Off Ver
    Excel 2016
    Posts
    18

    Question Automatically delete corresponding row after deleting a row from the master sheet

    I have uploaded the sample file, can somebody help me solving the problem
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Automatically delete corresponding row after deleting a row from the master sheet

    What's the problem?
    ________________________________________________________
    If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.

    Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.

  3. #3
    Registered User
    Join Date
    03-08-2014
    Location
    Kolkata
    MS-Off Ver
    Excel 2016
    Posts
    18

    Re: Automatically delete corresponding row after deleting a row from the master sheet

    Extremely sorry. I had uploaded the wrong one. Now I have uploaded the right one. The problem here is, when I delete any row from the master sheet the corresponding row in the other sheet showing error #REF. I want the corresponding row in other sheet also deleted.
    Attached Files Attached Files

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Automatically delete corresponding row after deleting a row from the master sheet

    As I understand your problem, this should solve it. You can add or subtract rows in the Master and the other sheet will reflect the difference:
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  5. #5
    Registered User
    Join Date
    03-08-2014
    Location
    Kolkata
    MS-Off Ver
    Excel 2016
    Posts
    18

    Re: Automatically delete corresponding row after deleting a row from the master sheet

    thanks newdoverman, it is working according to my requirement

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Automatically delete corresponding row after deleting a row from the master sheet

    Thank you for the feedback. I'm glad that it is working for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Master sheet updates and sub sheet automatically update as well
    By charscribbles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2014, 09:42 PM
  2. Replies: 3
    Last Post: 09-17-2013, 12:57 PM
  3. Copying (but not deleting) data from a master sheet to multiple worksheets based on Col A
    By SmartBalance in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2013, 03:09 PM
  4. insert/delete rows automatically to other worksheets when altering master list on sheet 1
    By whiskeycharlie77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2012, 08:10 AM
  5. Automatically transfer sheet content to master sheet
    By aegliveinterns in forum Excel General
    Replies: 3
    Last Post: 08-09-2011, 06:56 PM

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