jlcannon
asked on
VBA Code to loop through a csv file and select only the cells in a column that have names in them.
I have a csv file that only has data in column A. I have an excel workbook that I copy column A from the CSV to this excel workbook that I use to populate a mailing list. Problem is right now I am doing it manually. What I have been trying to find is how to have it so when I click a button it will copy all the cells in column A of the csv that have names in them to the excel file. All the information I can find on LOOPS show it using integers and I have text, can this be done?
Shums Faruk
Attaching a sample of your workbook and a csv would be helpful.
You just need to copy names from CSV? what about LOOPS using integers?
Name List is blank, will you have old Name List before copying new list?
ASKER
As the names get added to the list I want to be able to click a command button and copy all the names into the excel file. all the info I found on loops has to do with integers and I have only text.
I will clear the current names from the excel before adding the names from the csv. this is because the csv is only appended to so old names stay and new names are added so I will just recapture them from the first to the last.
I will clear the current names from the excel before adding the names from the csv. this is because the csv is only appended to so old names stay and new names are added so I will just recapture them from the first to the last.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow not only was it fast but the solution was 100% perfect. Thanks!
You'r Welcome! Glad it helped