invisigirl
Board Regular
- Joined
- Mar 18, 2002
- Messages
- 130
Let me preface this question with this statement: "I do not know visual basic at all." Just so you know that if you give me some code to use, it's gotta be exact so I can just copy/paste it in.
Okay, here's the deal. I have a huge download listing billing codes for lab tests. Y'all know that when you download out of gigantoid databases, you sometimes get a lot of crap that repeats at the top of every "page break." Well, I need to remove all that crap, and I'd generally just sort by the billing code column, get all the extraneous junk in one chunk of the spreadsheet and then delete it.
The problem is that there are test panels in this list that show a billing code for the panel name but not the test included within it. Therefore, I can't sort by the billing code, which is what it needs to be sorted by even AFTER I remove all the unnecessary info. See below:
SOMEONE'S MEDICAL LABORATORIES
UNIT CODE MASTER LIST
ACCOUNTS RECEIVABLE FEE SCHEDULE(S)
UNIT CODE BILLING NAME CODE PRICE
--------------- -------------------------- ------------ ----------
12345 ACETAZOLAMIDE 80000 12.00
12346 ACETONYLACETONE 80001 40.00
12347 ACHR BLOCKING ANTIBODY 80002 29.50
12348 ACHR BINDING ANTIBODY 80003 15.65
12349 MYASTHENIA GRAVIS AB PNL80004 95.72
12350 CULTURE,ACANTHAMOEBA
CULTURE,ACANTHAMOEBA 80005 41.12
ACANTHAMOEBA SMEAR 80006 19.36
60.48
Well, you see what a mess it is, but I'm used to dealing with it. Anyway, what I need to do is somehow remove all the lines where BOTH a test name AND a price are missing (I know how to remove the line if ONE particular column is not null, but don't know how to add another variable).
After that, I need to be able to fill the billing code down through all the blank cells beneath it (because with the blank lines removed, I won't have to worry about assigning a code to a line w/ no info in it).
FINALLY, I will then be able to safely sort by billing code & remove everything that's not necessary.
I really hope that list came in okay - if not, I'll post a reply & try again.
Can this be done or am I just dreaming?
(Sorry for the length of this question)
Okay, here's the deal. I have a huge download listing billing codes for lab tests. Y'all know that when you download out of gigantoid databases, you sometimes get a lot of crap that repeats at the top of every "page break." Well, I need to remove all that crap, and I'd generally just sort by the billing code column, get all the extraneous junk in one chunk of the spreadsheet and then delete it.
The problem is that there are test panels in this list that show a billing code for the panel name but not the test included within it. Therefore, I can't sort by the billing code, which is what it needs to be sorted by even AFTER I remove all the unnecessary info. See below:
SOMEONE'S MEDICAL LABORATORIES
UNIT CODE MASTER LIST
ACCOUNTS RECEIVABLE FEE SCHEDULE(S)
UNIT CODE BILLING NAME CODE PRICE
--------------- -------------------------- ------------ ----------
12345 ACETAZOLAMIDE 80000 12.00
12346 ACETONYLACETONE 80001 40.00
12347 ACHR BLOCKING ANTIBODY 80002 29.50
12348 ACHR BINDING ANTIBODY 80003 15.65
12349 MYASTHENIA GRAVIS AB PNL80004 95.72
12350 CULTURE,ACANTHAMOEBA
CULTURE,ACANTHAMOEBA 80005 41.12
ACANTHAMOEBA SMEAR 80006 19.36
60.48
Well, you see what a mess it is, but I'm used to dealing with it. Anyway, what I need to do is somehow remove all the lines where BOTH a test name AND a price are missing (I know how to remove the line if ONE particular column is not null, but don't know how to add another variable).
After that, I need to be able to fill the billing code down through all the blank cells beneath it (because with the blank lines removed, I won't have to worry about assigning a code to a line w/ no info in it).
FINALLY, I will then be able to safely sort by billing code & remove everything that's not necessary.
I really hope that list came in okay - if not, I'll post a reply & try again.
Can this be done or am I just dreaming?
(Sorry for the length of this question)