Hi All,

I have the follwing databse

OFFICE SALES COST MARGIN
100 1000 800 200
101 1200 900 300
102 800 700 100
103 1400 1200 200
.... .... .... ...
200 .... .... ...

Can I Use filter / advanced filter to select data based
on a few offices?

for eg. if I want to get data related to office
100,150,175,200 ?

I want to be able to change these offices. I want to
select several offices say 50, 75 etc at a time and these
office no's may change often.

How can I achieve this using code?

TIA
Soniya