-
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.
-
example sheet
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules