Hello,
I am new to creating Macros and need some major help. I have an Excel 2010 sheet with a large amount of data where all of the data is in a single column (A). I am needing to format it so that each data set is in its own row (and in different columns, of course). I assume I need to use a for loop, because not all data sets will have the same number of columns, using "Name:" as the indicator to start a new row.
Thank you in advance for any and all help with this!
Last edited by SUKAMC; 06-07-2012 at 02:50 PM.
SUKAMC,
Welcome to the forum!
Assuming the data is like your sample and starts in cell A1 and the first cell contains "Name: xxxx", then this should work for you:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Tigeravatar,
That is awesome thank you! There is one problem with it, but that is my fault because I failed to point it out. Sorry.
If you look at A11 and A12 from the example data I attached, A12, if possible, should be concatenated with the data in A11. The data that needs to be concatenated, like in cell A12, will never have a colon within the cell.
Updated code. It assumes any cell without a colon should be concatenated to the cell(s) above it:
Please Login or Register to view this content.
Last edited by tigeravatar; 06-07-2012 at 03:53 PM. Reason: Updated code to turn off calculation, events, and screenupdating; changed the redim method for arrdata
Perfect!
Thank you so much.
You're very welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks