View Single Post
  #1   Report Post  
Picc Picc is offline
Junior Member
 
Posts: 4
Default Not incrementing cell reference

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