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,
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,
Last edited by kamalmalek; 01-05-2012 at 06:03 PM. Reason: wrong update
In F1:G5 put the criteria range
ss qty
01 <=-100
03 <=-10
04 <=-10
05 <=-10
and use AdvancedFilter.
Thanks V much
gr8 answer indeed