hi,

i need a vba code

for simple purposes, i create a worksheet

in column A : Company Names
in column B: The sector, company belongs
in column C: Net sales

i want to filter net sales according to multiple criteria

if the sector is food and beverage then show the row if the net sale
above 200
if the sector is Textile then show the row if the net sales above 60
or any other criteria

how do you set multiple criteria in the same column?

thanx in advanc

+-------------------------------------------------------------------
|Filename: sectordata.zip
|Download: http://www.excelforum.com/attachment.php?postid=3697
+-------------------------------------------------------------------

--
barkin
-----------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...fo&userid=2039
View this thread: http://www.excelforum.com/showthread.php?threadid=39639