Hello
I am trying to copy a formula down a column, but the reference on another sheet does not run in the same sequence as the cells it is to be copied into
It's the basic SUM formula, but the original sheet has the information in cells A3 then A6, A9 etc. But the data needs to be used in a formula where the cells used will be sequential. B2, B3, B4 etc.
Is there a quick way to get the formula to copy in this way and not replicate the original sheet?
I have attached the sheets that I am working on, with some further notes to help anyone that can save me!!
Thanks in advance
Bookmarks