Apr 21 2019 05:36 PM - edited Apr 21 2019 06:49 PM
My goal is to copy a range of cells and have all the formulas in the copied range of cells pasted into a new location keeping the original formula references. I.e, I will have two identical data in two sets of cells on a sheet.
E.g. one of the cells in the range to be copied might have a formula similar to, "='sheet 2'!K75". I wish for that formula to be pasted into the destination cells and be "='sheet 2'!K75".
Apr 22 2019 02:12 AM
@Tim_Parisi , you may use absolute references for that
='sheet 2'!$K$75
Apr 22 2019 04:28 AM
Apr 22 2019 04:45 AM
@Tim_Parisi , both assume changes cell by cell. To copy entire range the workaround could be
- select entire range
- Ctrl+H and replace = on #
- copy/paste the range on new location
- select range, Ctrl+H and replace # on = (for both ranges)
Dec 03 2023 06:18 PM