Hi Roger,

Although that works absolutely brilliantly, I need it to update itself
aumatically everytime data is entered into another sheet. This is being
created for use by others who are not familiar with Excel functions..

Any ideas??


--
rhani111
------------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=386046