"Sowparnicka" wrote:
.. say A to z in the specific column
i want only A B C in that column
Rest all should be deleted along with the Row.
Why macro? .. especially when a couple of simple steps using autofilter on a
helper col will deliver it in a matter of seconds
Let's say that specific col is col A, data in row 2 down
In B2: =OR(A2={"A","B","C"})
Copy down to last row of data in col A
Apply autofilter on col B choose: FALSE
This filters out all the rows to be deleted
Select all the filtered rows (select row headers), right-click Delete Row
Remove autofilter. Done
High five?, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---