+ Reply to Thread
Results 1 to 1 of 1

Insert/Delete rows across worksheets

  1. #1
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,178

    Insert/Delete rows across worksheets

    Iíve received help with this formula here before and it works great until I insert rows.
    On sheet 1, double click on a cell in column A to insert rows. Just for testing insert has been set to 2 rows.

    The adding of the rows works fine, but it causes a circular reference in column AD. I noticed the formula starting in AD8 was not copying right so I added to the code to take the formula in AD8 and copy it down which seems to work fine, but still, a circular reference is generated.

    If I add new data to column AC the formula updates correctly, but the trouble comes from the cells highlighted in grey on Sheet 2 and 3.

    The data in AD is later used to populate a chart so I need the roll up in AD8 and AD14 so I can chart by the Major category. Of course this is much larger and this is only a test.
    Any thoughts?
    Attached Files Attached Files
    HTH
    Regards, Jeff

+ 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