@jdraw: Thank you for your response. I completely agree with your thinking and would have responded the same way. If the "refnum" is unique, what's the point of creating another unique ID.
My issue is that I can't control the way I get data at my company. I have to go thru a macro-enabled...