I had come previously for help with a formula in This Post.
1.
The formula seemed to have been working at the time, however once I added to it and began testing it using multiple inputs, it stopped properly working. It would only convert, transpose, and format the first input, multiple times in the outputted area.
What the output is suppose to look like
What the output actually looks like.Please Login or Register to view this content.
2.Please Login or Register to view this content.
Originally, the VBA script was to...
1. Take the inputs, each located in their own cell in the first worksheet
2. Convert them from their comma deliminated format
3. Transpose them into the second worksheet
4. Format them by deleting cells, moving infromation around etc.
5. Go on to the next input and repeat the process.
3.
Example Input Located in a Single Cell
Please Login or Register to view this content.
Current VBA Script
4.Please Login or Register to view this content.
Additionally I have attached a copy of the excel sheet to this post.
Attachment 342729
I appreciate any and all help. Thank you!
Bookmarks