Forum Discussion
Have a formula that repeats to an exact pattern
Hi I am trying to create a simple 'sum' formula on a worksheet that pulls through data from other sheets in the same work book. That bit is simple enough, but i need the pattern of the data to be...
It depends on where these next several cells are and what means etc
If, for example, in A3 is =SUM(Sheet1:Sheet3!A1), you may copy paste it to C3 and it'll be =SUM(Sheet1:Sheet3!C1)
If next cell is down, or next to the right, or something else - perhaps some formula could be used.