thank you so much. that has worked a treat.

i made the formula "real life" into a hidden sheet, and now the user
just has to post the data into the initial sheet and it will then
update a summary sheet accordingly.

again, thanks alot :)


--
mdma
------------------------------------------------------------------------
mdma's Profile: http://www.excelforum.com/member.php...o&userid=24284
View this thread: http://www.excelforum.com/showthread...hreadid=553169