PDA

View Full Version : remove <100&10



kamalmalek
01-05-2012, 05:52 PM
dears expert,
i attached file as i want:
to delete all qty >-100 if ss "01"
to delete all qty >-10 if ss "03,04,05"
i sheet "after run micro" exactly my requirement,
thanks to update me necessary vba code for this,

mikerickson
01-05-2012, 09:29 PM
In F1:G5 put the criteria range

ss qty
01 <=-100
03 <=-10
04 <=-10
05 <=-10

and use AdvancedFilter.

kamalmalek
01-06-2012, 03:59 AM
Thanks V much

mostafa90
01-06-2012, 10:30 AM
gr8 answer indeed