Matching Columns

[Buddy7]

I want to add these numbered steps onto the macro I already have, which I pasted below.

1. Starting in Row 2 in the worksheet named Report 1 look at contents in Column A then look at the contents in Column C, if the contents in Column C do not match exactly the contents in Column A then copy the contents in the range column C:E from that row till the last row in Column C:E.

2. Now we will have a range that is made up of cells from C:E. I would like to move that range down a row at a time, until the first cell in Column C from the range Column C:E matches exactly the contents in Column A. Then I would like to continue this pattern for every row in the worksheet. Do you think you can help?

Please Login or Register  to view this content.

[JBeaucaire]

Yes, but just to be sure, any chance for you to post up a before/after workbook so we can see the goal?

Click on GO ADVANCED and use the paperclip icon to attach a workbook to your next post.

[Buddy7]

I think there is going to be a better way to do this, than what I am proposing here. I am going to close this thread, and plan this out a different way. Thank you very much for your help.