Excel 2010 VBA Script Need to separate field values into cells

[Jawnne]

Hello All,

I have a worksheet that I export from another program to Excel, the worksheet has one cell that contains all the resources required for scheduling appointments. Which are all separated by a semicolon. All of which have its location followed by an '@' symbol. The last resource does not have a semicolon.

I want to have a script that takes each part of this and separates them (like text to columns) but arranges them in predesignated columns based on the type of resource and location.

Any help on this would be much appreciated.

John

 

[hiker95]

Jawnne,

We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com