copy offset and paste loop

I still have trouble with the loop and the coding. if any one knows of a very simple explaination I will gladdly look at it. I understand the principle, but struggle with the code.

anyway.

I have numerous rows of data with column A empty. columns B and C always has data and column D sometimes has data.

What I want to do is find the blank rows in column D,
offet by 2 to column B,
copy or cut that cell value and paste it into the same row in column A.
I then need it to repeat this until all blanks in column D have looped.

Then I want to get the value in column A copied down until it reaches another value in column A,
at which point I want to copy that new value until the next value etc etc


regards
Paul

Could you post either the code you are having trouble with. Together with an example of what you want it to do.

I removed all the code as it wasnt doing what I wanted.

The sample sheet is attached

basically what I would be doing is inserting a new column in B so A and B would be empty.

where the value in now column C is like 013-, then copy this value plus the value in D to column A and B.

loop this until column C is empty.

copy this values in A and B and paste down until it reaches a different value.

hope this makes it a bit clearer.

regards