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

VBA group the number in the Column and Copy to the new worksheet. 0
merge worksheets 3
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Search multiple worksheets and return value to main worksheet 7
Split worksheet into multiple worksheets 10
CopyPasteSortCountMacro 3
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1

Top