Loop to retrieve value in worsheet A and put into worksheet B

D

D

I am hoping someone out there cyber-world can help me with some code that I
need. I have a workbook from an outside source. I need to loop through
Worksheet named "Details", column A to find the characters "C:" and return
the value from Worksheet "Details" , column B into Worksheet "New Details",
Column A. There are blank rows in the data and the only designation between
what would be considered a new record is a series of dashes (14 dashes to be
exact). Is Anyone able to help with this? Anything is greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Move rows to another worksheet with vba 4
Put Formula in VBA 1
Need VBA Macro to Loop through pages and print counter in footer of each page 9
merge worksheets 5
Take active cell value in for loop and offset based on another cellvalue for columns to offset 0
Code to Concat a row in loop 2
Trying to loop 4

Top