Hi Rhani

Perhaps using Advanced Filter to extract data from one sheet to another with
the user having entered their criteria on the lookup sheet would be the
answer.

Take a look at the many examples regarding Advanced Filter posted by Debra
Dalgleish on her site
http://www.contextures.com/tiptech.html
and I am sure you will find a solution

--
Regards
Roger Govier
"rhani111" wrote in
message ...

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