Need to duplicate (cut / paste ?) formulas but can't use $ (F4)

  • Thread starter Thread starter hojikuru
  • Start date Start date
H

hojikuru

I have a massive array of formulas in three columns that I need to
duplicate to the next three columns exactly as-is. I cannot use F4
b/c there are too many formulas to edit individually.

If I cut the original columns, I can paste the contents into the new
three cols, but I can't re-paste them back into the original columns.
This would be ideal, but I don't know how to do it.

Is there another way to exactly replicate the contents?

One other complication is that the target cells do not sequence with
the parent cells (rows = columns & vice versa; they're transposed and
nonsequential), so I can't do a typical trick like inserting new rows,
offsetting them, copying/pasting, then dragging them into the new
position.

Example:
A B C
1 =D2 =D4 =D8
2 =C2 =C4 =C8
....

I need to replicate the above to
D E F
1 =D2 =D4 =D8
2 =C2 =C4 =C8
....

Thanks,
Michael.
 
Try the following on a copy of your data:

Select the cells you want to copy
Choose Edit>Replace
Find What: =
Replace With: x=
Click Replace All

Copy the cells to the new location

Select the original cells and the copied cell
Choose Edit>Replace
Find What: x=
Replace With: =
Click Replace All
 
Back
Top