On Fri, 11 Nov 2005 00:21:02 -0800, "MarkN"
wrote:

Thanks Ron,

It worked on a smaller sample than discussed, I will let you know if I have
any problems on a larger sample.
--
Thanks again,
MarkN

Mark,

Glad to hear that.

By the way, an issue with the VLOOKUP part to bring over the associated data is
that if a matching cell is empty, it will result in a zero (0). So you might
either want to check for this, or use a custom format so zero's are not
displayed (depending on whether there might be a valid zero in those fields).


--ron