Hi Claire,
Possibly the fact that you have merged cells is
obscuring what you are actually trying to do, does it work
if the cells are not merged. I am assuming that your
cells are merged across and not down.
Try copying to cells that are not merged.
If you copy formulas the formulas will be adjusted to
where they are pasted to and will refer to the same page
that they are on as they will not refer back to the first page
unless you had sheet references in the formulas to begin with.
If you want the cells on the second sheet to refer back to
the first page and the formulas can be coped down by use of the
fill handle (and the merging is same amongst the cells on
the second page is merged across cells on one row per use.
K | Val | Formula
54 | 99 | =A2+A3
45 | 139 | =A3+A4
94 | 143 | =A4+A5
49 | 121 | =A5+A6
72 | 129 | =A6+A7
57 | 57 | =A7+A8
sheet 2
D2: =sheet1!B2
and fill down with fill handle
Create the formula in D2 by placing =
sign into cell D2 of sheet2 then click on cell B2 on sheet1
then hit Enter, which returnjs you to sheet2. Use fill handle
to copy down.
If you had cells in D and E merged across rows on the second
sheet the above works the same way. Remember a merged
cell is addressed by the upper left corner of the merged cell.
If that does not help you will have to be more specific about
how cells are merged, and what the formulas are from the
source and what you got and what you expected to see on
the second sheet.