I know this must be a simple answer,
I have the following cell D5 = A5, and E5 = A6.
I want to be able to drag these down so D6 = A7 and E6 = A8 and so on down.
Obviously i am dragging and getting D6 = A6 and E6 = A7.
what is the solution?