Results 1 to 7 of 7

Keeping cell reference the same after inserting rows

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    Orlando
    MS-Off Ver
    O365
    Posts
    24

    Keeping cell reference the same after inserting rows

    I have a worksheet which copies a group of cells below the last data line in row A by using a macro and a button. When the button is hit the range A30:DQ54 is copied and pasted below the last row of data in row A. This works well.

    The problem is I need the formulas in columns I to P (I30:P54)to reference the Yellow Row even when inserting rows in the section just copied. This can be seen in the range A80:DQ104 on the attached sheet, in this range I am able to make the formula with absolute numbers so when inserting rows the formulas still reference the yellow row (Row 80). The problem formulas are only in the columns I-P.

    My question: is there a way to write the formula in cells I30:P54 so that when they are copied with the button, the formulas will always reference the yellow line even when inserting new rows between the top row (yellow) and the bottom row (green) of the range? (After copying)

    I've attached the page so you can see the problem better.
    Attached Files Attached Files

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