PDA

View Full Version : copy offset and paste loop



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

mikerickson
11-20-2007, 05:54 PM
Could you post either the code you are having trouble with. Together with an example of what you want it to do.

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