morbenforsen
New Member
- Joined
- Jul 4, 2015
- Messages
- 20
i have a column (col k) which contains numbers that correspond to a certain row (not in continuous sequential order)
example values; k2=194, k3=326, k4=631, k5=1011 etc.
I want to keep only the rows in the worksheet indicated by each value (I want to keep the entire row 194, row 326, row 631 etc etc.)
It doesnt matter if I copy these to another sheet, or delete all the other rows, etc.
I am hoping to find the shortest way to accomplish this with VBA.
All help is most graciously appreciated.
example values; k2=194, k3=326, k4=631, k5=1011 etc.
I want to keep only the rows in the worksheet indicated by each value (I want to keep the entire row 194, row 326, row 631 etc etc.)
It doesnt matter if I copy these to another sheet, or delete all the other rows, etc.
I am hoping to find the shortest way to accomplish this with VBA.
All help is most graciously appreciated.