Welcome, good to hear that.

The If statement in A2 where you currently
have "Sheet1!B2100" could be more complex and
I could use the AND/OR in here if there are multiple criteria

Yes, of course. Just frame it up to suit your actual criteria to be applied.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"PAL" wrote in message
...
Well Max,

This works great. I have no idea how, but it does. This is a toughie
because I am not familiar with most of the functions. TI will try to
learn
them. Thank you.

A question if I may:

The If statement in A2 where you currently have "Sheet1!B2100" could be
more complex and I could use the AND/OR in here if there are multiple
criteria.