Originally Posted by Picc

Is it possible to copy and paste a cell with a formula containing a reference to another sheet of data into a cell on another row without incrementing the cell reference?

Sheet1
1A(x)
2A(y)
3A(z)

Sheet2
1A(x)
2A
3A(y)
4A
5A(z)

So that the rows are shipped on sheet2 but the reference is not skipped sheet1.

Thanks