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