I've managed to land in a temp job that, well, could be better. Right now I'm trying to improve an aspect of it. I receive two printed reports, I compare the two, and if I find matching ID numbers, I cross them off of one report.
Yeah, considering it comes from a database, I was stunned at this task also.
So I've managed to get them to at least TRY and send me an electronic version of the two reports. The problem is, the resulting file will look like the printout. Title on every page, page numbers, column headers, the works.
And it's not just single row entries either. For each ID number, there will be at least 2 sub rows. The ones without a ID number in the first column are a subset of the row above it, with a with an ID number. Sometimes these lines contain a sentence that must be kept with the original line.
I'm probably going to have to write some serious VBA for all this, but I'm curious if there is any resources out there that I can use. Or if you guys have any other suggestions.
Ultimately I'd like to import the report into a table. Then I can do all the timesaving stuff that will make my boss's head spin.
(People are already getting excited about this. "An electronic version of the report? Imagine what you could do with that!"
And as much as I'd like the company to send me a useful list, I'll be amazed if they manage to send me anything at all. So access to the database they use and other helpful suggestions along those lines won't work.
