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

No need for VBA.

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

Dm Unseen

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'

---
Regards,
Norman



"barkiny" wrote in
message ...

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 sales
above 200
if the sector is Textile then show the row if the net sales above 600
or any other criteria

how do you set multiple criteria in the same column?

thanx in advance


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

--
barkiny
------------------------------------------------------------------------
barkiny's Profile:
http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=396392