Using Values from Column to Filter Another Column

**zmster2033** · 10-21-2014, 04:56 PM

Good afternoon,

I am ultimately looking to delete items in Columns A-C where Col. B does not equal one of the values in Col. F.

I am thinking this may need to be done with a loop, but not sure how to go about achieving this. I have a variable that counts the number of rows in Col. F which I feel would need to be used.

Any assistance is appreciated.

Thanks.

**venkat1926** · 10-22-2014, 03:00 AM

equal one of the values in Col. F

I suppose you mean any of the cells in col F not necessarily in the same row

as you are messing with with data copy data (in sheet1) to sheet2 also to preserve the data

the data in sheet 1 (and also in sheet 2) will be first like this

hdng1 hdng2 hdng3 hdng4 hdng5 hdng6
1 2 3 x x 2
4 10 6 x x 3
7 8 9 x x 4
3 5 7 x x 5
2 7 9 x x 6

try the macro "test". macro "undo_macro" is to get back original data in sheet1

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**zmster2033** · 10-22-2014, 12:15 PM

Venkat,

Thanks for the reply. Unfortunately I could not get that work and have created a For loop for this. It gets the value for each item in the Critiera list and filters based on it.