wolf.stalker
11-13-2010, 09:58 AM
Greetings and thanks for the help!
need help putting something together. i have enlcluded the test workbook so that you can see my data. so, if you are looking at the workbook, this is what i need to "code"
on the "Data" sheet will contain some 10k rows of data. I want to look at comumn L and take that value and see if it's in the list on the "temp" sheet. if it is NOT then i need to delete all info up the new test point.
Example. I am looking at cell L1. that value "T077" is in my list on sheet "temp" so i will move on to the next value in column L which is "T190" at L4. That value is NOT in the list so i want to delete rows(4:8) or up where the next value in L is.
thanks again for any help you can provide!
need help putting something together. i have enlcluded the test workbook so that you can see my data. so, if you are looking at the workbook, this is what i need to "code"
on the "Data" sheet will contain some 10k rows of data. I want to look at comumn L and take that value and see if it's in the list on the "temp" sheet. if it is NOT then i need to delete all info up the new test point.
Example. I am looking at cell L1. that value "T077" is in my list on sheet "temp" so i will move on to the next value in column L which is "T190" at L4. That value is NOT in the list so i want to delete rows(4:8) or up where the next value in L is.
thanks again for any help you can provide!