There are a few things I need to be able to do in macros, which I have no idea how to do, im not very good with VB at all.
First: To insert 2 columns at specific point (Just the same as right click, insert x2)
Second: Data in columns B needs to be changed so it does: Data Tab(at top of screen) > Text to columns > Delimited > Uncheck "Tab" > Check "Other" > Insert "-" > Press Finish
However the whole of B isn't data, it has groups of data and i change it alot so its not the same, I need a way to make sure it only does the second part of the macro to cells with data with the structure of: *-*-* (the *'s are numbers or letters...)
I have no idea if its possible to see what cells have no color in the background and for it to only run the second part of the macro on them
Example: http://img291.imageshack.us/img291/6245/123lsi.png
Bookmarks