Hi
I m creating a worksheet where I have to bring the data from another worksheet and add for 7 cells.
e.g. worksheet w1 cell a1 has =sum(W2!a1..a7)
a2 should have =sum(W2!a8..a14)
a3 should have =sum(W2!a15..a21) and so on
when I write the formula in A1 and copy or extend it to A2 its taking A2 as starting cell instead of A8.
Help please! how do I copy the formula so it will take =sum(w2!a1..a7) in a1 and =sum(w2!a8..a14) in a2 and =sum(w2!a15..a21) in a3 and so on.
Bookmarks