You're welcome, Dan !
Thanks for feedback ..

.. how to do this via an integrated function
Just some thoughts (but do hang around for insights from others) .. Formulas
eg: an INDEX/MATCH placed within the AIM col can only return/populate one B4
value into 1 correct cell in the AIM col at any one time. It cannot then
"freeze" the value there. So when B4 is re-input by the next user (with a
different email in B3), the AIM col formulas will recalc and return the B4
value into another cell correctly, but we would lose the B4 value returned
for the earlier user.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dand06" wrote:

That's a great little sub! Exactly what I was looking for! If anyone
else can think how to do this via an integrated function (so people
don't freak out about giving this sheet Macro permissions), I'd be most
appreciative!

But thanks a ton Max!
Dan


--
dand06
------------------------------------------------------------------------
dand06's Profile: http://www.excelforum.com/member.php...o&userid=34646
View this thread: http://www.excelforum.com/showthread...hreadid=544091