VBA code I wrote this week in Excel and how it helped me
Posted by: John R. Durants WebLog,
on 30 Oct 2009 |
View original | Bookmarked: 0 time(s)
OKmy title is kind of colloquial. But I'm in a hurry, and the title conveys the idea well enough.
Here's the deal: I have a spreadsheet with a bunch of important data. But, some of the most distinctive data are all merged into one cell. To make the data more usable, I needed to parse the data elements in that cell and separate each out into its own column. That way, I can filter and sort for each specific element. VBA made this possible and in short order (see my recent post Why VBA Still Makes Sense).
Here's...