multiple criteria in one column VBA urgent need!

[barkiny]

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
+-------------------------------------------------------------------

 

[DM Unseen]

No need for VBA.

you just nee Advanced Filter on the Data/Filter menu.

Dm Unseen

 

[Norman Jones]

Hi Barkiny,

As DM Unseen says, use the Advanced Filter feature.

To employ multiple criteria for a single field, simply use multiple criteria
rows.

If this is not immediately obvious, see Debra Dalgleish at:

http://www.contextures.com/xladvfilter01.html

See particularly, the section entitled: 'Setting up the Criteria Range'