"jonhunt" wrote:
Thanks. I'd been working on this after posting the thread and found
another way to make it work...posted below, but I followed your example
and it works great.

Good to hear you got it worked out as well.
Thanks for posting back & sharing your findings with us.

But what do you mean by "freeze the values....then do an in place.?"

Freezing the values returned by the formulas in cols B to D means to kill /
remove the formulas while leaving the evaluated values behind. And one way to
do this would be to copy cols B to D, then do a paste special values over
"itself" (ie. an "in-place" paste special over cols B to D). The freezing as
values would allow us to then clean up & delete any unwanted cols, eg: delete
cols A and C in the example set-up, so as to yield the final product.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---