Yes, you missed the part that there are a tad over 80,000 cells than
need to be replaced and I am working with about 3 days to do this. :)


I have done that before when the data was smaller and less
convoluted.... but this is just a giant mess of values and tables.

I remember reading in a book I have lying around somewhere that there
was a way to do this via a script.... but I can't find the book now. I
think I lent it to a co-worker....


--
Emoshag
------------------------------------------------------------------------
Emoshag's Profile: http://www.excelforum.com/member.php...o&userid=22190
View this thread: http://www.excelforum.com/showthread...hreadid=558894