Hi,
I am from a clinical lab. I have a situation where a set of analysis results for a patient has to be interpreted based on the Range cutoff given. I need to compare and figure out which set of cutoff will provide better clinical interpretation. This would require me to compare huge amount of patient data.
I have attached an excel file "Cutoff comparison" for your perusal. In it there are three worksheets: "Raw data", "Compare" & "Cutoff".
"Raw data" worksheet contain data obtained directly from the analyzing instrument. Each patient sample is analyzed for various parameters/analyte. I have named them for convenience as P1, P2 etc. I have added 4 rows of data, but it can be more than 100 rows at a time.
In "Cutoff" worksheet, I have specified a set of two upper and lower cutoff limits (Cutoff limit 1 & 2) based on two applicable ranges for each of the parameters (P1, P2,P3,...).
For my patient result comparison, in my "Compare" worksheet, I would like to copy each ROW from the "Raw data" sheet and paste it in "Compare" worksheet. Also I need to create a duplicate ROW with the same data value below it. The duplicate ROW cell gets a BG colour changed to "Grey" or any other colour and the serial number (S.No) also gets renamed for identification, in this case "a" was suffixed to it.
The values in each of the duplicate rows are then compared with either one of the cutoff limits specified and any cell having value above or below the cutoff limits gets highlighted (here font colour changed to "RED"). Like the upper Row of raw data is compared with Cutoff limit 1 and the duplicate lower raw data is compared with Cutoff limit 2.
I have currently compared the values manually.
I need a macro/any other means to execute this action in "Compare" worksheet. Can anyone suggest how to go about it?
I tried recording the macro, I could record copy and paste of raw data; but comparing was not possible. further I cannot do it for "n" number of rows.
Any help is much appreciated.
Thanks in advance
Regards
Daavis.
Bookmarks