wibbers2000
11-20-2007, 05:48 PM
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
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