Wednesday, August 19, 2009 1:54:29 AM
Argh. I was recently given a "list" from another department. I was supposed to load some new records as well as update others. Wouldn't have been bad, except that this "list" was an Excel workbook with data spread around multiple worksheets.
Usually I take things in stride and just work with what I'm given, but "multiple" in this case meant dealing with nineteen (19) worksheets. Nineteen worksheets with both updated and new data co-mingled! Now if there were any semblance of order within those sheets, I might have created a macro to go through everything systematically. I basically needed three columns (ID, NAME, VALUE); so what did I get? Worksheets that had columns ending usually AE and AF, and one oddball at K -- that's 31, 32, and 11 columns. To further complicate it, columns were hidden inconsistently among the sheets. Oh, that's not all. There were also blank lines between the data. Blank lines may make lists look a bit more readable to some people, but OMFG does it ever make going through the list a big pain.
Fed up, I asked that the data to be consolidated into one workbook containing two worksheets: one for updates and one for new records.
I got back two workbooks: one for updates containing 6 worksheets, and one for new containing 9 worksheets.