Rayne
asked on
Extract data from column into pieces (Excel 2007)
Hi,
I have attached a sample excel file that list a specific piece of string data in column A. I want only specific pieces of data listed in separate columns as shown in picture. How do I do a VBA to accomplish that. I have about a large number of rows to work on. Thanks for your assistance.
-Rayne
SampleInfo.xlsx
I have attached a sample excel file that list a specific piece of string data in column A. I want only specific pieces of data listed in separate columns as shown in picture. How do I do a VBA to accomplish that. I have about a large number of rows to work on. Thanks for your assistance.
-Rayne
SampleInfo.xlsx
Rayne,
I'm taking a look at your sample file and I don't see anything in column A. Also, what specific pieces of data are you trying to extract? And what cells are you extracting them from?
thanks,
aebea
I'm taking a look at your sample file and I don't see anything in column A. Also, what specific pieces of data are you trying to extract? And what cells are you extracting them from?
thanks,
aebea
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Patrick,
I tried your solution. The project name is working but the factor is not working...its giving !REF error in excel. See attached.
Thank you again
-Rayne
CaptureInfo-II.PNG
SampleInfo.xlsx
I tried your solution. The project name is working but the factor is not working...its giving !REF error in excel. See attached.
Thank you again
-Rayne
CaptureInfo-II.PNG
SampleInfo.xlsx
ASKER
Awesome Help
ASKER
CaptureInfo.PNG