I need to separate data in column B that has a comma separating the numbers into one column and keep the value of column A tied to the data being separated. The new data needs to go to a new sheet. I have attached a sample what is needed.
Sample.xlsx
Last edited by Tenos; 03-12-2012 at 09:39 AM. Reason: sample not clear
Hi tenos
Welcome to the Forum!
This code seems to do as you require. Let me know of issues.
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
hi Tenos, option, press "Run"
Works great. Thanks for the help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks