Inserting copied cells in one sheet without shifting cell references in another sheet
I have a master sheet with multiple entry rows and other sheets that reference cells in the master sheet. When I insert copied cells from another source into the master sheet and shift cells down, the references in the other sheets also shift down. I’m attempting to insert additional data in the master sheet without changing the other sheet references. I’ve tried both absolute and relative cell references in the other sheets with no luck. Also, copying values only doesn’t work because I need to shift content down on the master sheet.
I have a master sheet with multiple entry rows and other sheets that reference cells in the master sheet. When I insert copied cells from another source into the master sheet and shift cells down, the references in the other sheets also shift down. I’m attempting to insert additional data in the master sheet without changing the other sheet references. I’ve tried both absolute and relative cell references in the other sheets with no luck. Also, copying values only doesn’t work because I need to shift content down on the master sheet. Read More