title: Exclude other cells from counting of references when copy and pasting formulas
body: <p>I would just like to ask how can i copy and paste formulas that would have a continuous count. In my case, I have this formula "='PRODUCTIONSTATUS'!B940" located in cell D8, I would like to copy it to cell J8 and wanted to have a formula of "='PRODUCTIONSTATUS'!C940" because when I do the normal copy and pasting, the one that would reflect to cell J8 was  "='PRODUCTIONSTATUS'!H940". I hope somebody can help me. It would be of great help. Thanks.</p>