nrgmechanics
New Member
- Joined
- Apr 19, 2012
- Messages
- 10
I need major help!!!!! I work in the medical field and deal with patient testing. I basically print out an entire patient database from two separate systems base on PDF files.I compare the two lists and make sure they match. I’ve tried my own and other suggested formulas and macros, but they conflict with each other or don’t work.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
List #1, This is the first list.
<o></o>
></o>
This is the raw data from the PDF file that I copy and paste into Excel, this is exactly how it looks. When I paste it, it all falls into one column. There are three patients with a series of "test codes" behind. If there are alot of codes at the end of the page, it will drop and continue down on the next line. This is only an example of three, but I get a list of over 2000 patients. The amount of test codes is always random, some can be one test code and other can be 50 test codes.
<o></o>
For Tony Stark, there are so many codes that it is on 3 rows.
For Stever Rogers, the codes are long enough to 2 rows.
and Bruce Banner is only on the 1 row.
<o></o>
List #2, The second list from the other PDF file.
<o></o>
></o>
This is where I get stuck. When all the information gets pasted into excel from the PDF file, it’s just horrible. Also, the tests are always jumbled into a different order. Have to keep that in mind.
<o></o>
I need List #1 & #2 to be broken by Patient number and the test codes. All of List#1 into a column and List #2 into another column and match by patient number, if all the codes match.
<o></o>
></o>
I’ve tried to do this in three steps. Simplify List 1, Simplify List 2 and then match, If no match, highlight unmatched.
<o></o>
Maybe you can come up with another approach. Please help, I still do this the old fashion way by printing both lists out and comparing. My eyes hurt after 3 hours!!! There has to be another way. Any extra time I get I try to work on this excel form, but I can’t figure it out L
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>List #1, This is the first list.
<o
></o><o
></o>This is the raw data from the PDF file that I copy and paste into Excel, this is exactly how it looks. When I paste it, it all falls into one column. There are three patients with a series of "test codes" behind. If there are alot of codes at the end of the page, it will drop and continue down on the next line. This is only an example of three, but I get a list of over 2000 patients. The amount of test codes is always random, some can be one test code and other can be 50 test codes.
<o
></o>For Tony Stark, there are so many codes that it is on 3 rows.
For Stever Rogers, the codes are long enough to 2 rows.
and Bruce Banner is only on the 1 row.
<o
></o>List #2, The second list from the other PDF file.
<o
></o><o
></o>This is where I get stuck. When all the information gets pasted into excel from the PDF file, it’s just horrible. Also, the tests are always jumbled into a different order. Have to keep that in mind.
<o
></o>I need List #1 & #2 to be broken by Patient number and the test codes. All of List#1 into a column and List #2 into another column and match by patient number, if all the codes match.
<o
></o><o
></o>I’ve tried to do this in three steps. Simplify List 1, Simplify List 2 and then match, If no match, highlight unmatched.
<o
></o>Maybe you can come up with another approach. Please help, I still do this the old fashion way by printing both lists out and comparing. My eyes hurt after 3 hours!!! There has to be another way. Any extra time I get I try to work on this excel form, but I can’t figure it out L
