Copying text from cells until text in a certain cell changes

Hello Everyone,

I am glad to be apart of this forum! I have a moderate amount of experience with C# but not VBA. What I am trying to do with a macro is copy text from column D if it has the word Van in it. If it does have the word Van in it, I am trying to paste the text in this cell in column A. Until however, another cell in column D has the contains the word Van in it. Which from here new text will be copied starting off on the row.

I know that this will need to contain a loop of some sort. Can anyone help me out with my issue?



Question.PNG

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post