copy, paste and loop

[zinoviia660]

Good afternoon,
I need help copying from an offset column and then filling down. I know how many columns I have but the number of rows will vary so I can't set up a specific range.

My column names are A, B & C. As long as there is data in Column A, I need to copy the contents of cell B3 and paste it into cells C3, C4 and C5. But when the text in Column B changes, or when the first 8 digits in Column A change, I need the information in the adjacent B cell to be copied and pasted instead until the next change.

Please see the attached spreadsheet. I have given an example of what I have and what I want it to look like.
Thanks!

[JBeaucaire]

Put this formula in C3 and copy down:

=IF(LEFT(A3,8)=LEFT(A2,8),C2,B3)

[JBeaucaire]

The same solution in macro format:

Please Login or Register  to view this content.

[zinoviia660]

Thank you so much for both solutions! The formula helped me understand the code.

The only thing I needed to change was
With Range("C2:C" & LR) .......changed to..... With Range("C3:C" & LR)
Otherwise, my the column header gets changed, too.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.