selector to delete data

Would you like a new column "F" that indicates which rows you want to delete?

Would you like a new column "F" that indicates which rows you want to delete?

Yes Martin !

Column F is an great place because
 it don't have any data

Oh, and if you click a cell in column "F" it will change to a checkmark (and back again if you click it again), and then when you click 'Clean Data' just the rows with a checkmark will be cleaned.

Is an Great Solution !!

Best Expert !

You sent me a message that this isn't working correctly. Please describe what's wrong.

Martin

the solution is showing in history
some incomplete data

for example i do this

put this data as show here


this data goes until column


here the total columns and count


but

in the history the data is not the same
as show here



here the file with the data  on


Please Best Expert help on this !
To_look_for_f1_f2_f3.xlsm

Martin

this tool will have always a lot ofs data as input

the range will be  a lot higher always    

i mean a lot of column  will be

from column F to KT in this sample

this tool will have always a lot ofs data as input

the range will be  a lot higher always    

i mean a lot of column  will be

Please translate that for me.

muchas  columnas seran utilizadas  

siempre con datos

"many columns will always be used with data"

Quiero decir que ampliar el rango de columnas a ser utilizadas con datos  puede ayudar

I mean, expanding the range of columns to be used with data can help

I believe it's working correctly now. In addition to correcting the problems you pointed out I did the following:

• When you click one of the buttons on the V_OUT sheet and there is no data in that column, an error message will appear.
• The V_OUT sheet from rows 3 on down will be cleared before each new search. If you don't want it cleared I can change it.
• The yellow cells in row 3 on the V_OUT sheet will always be yellow, always numbered, and always sized to fit the data that's in the column.

29080402a.xlsm

This version does NOT clear the previous results. Use whichever one you want.
29080402b.xlsm

Great JOB !!

Martin

Triying to work with this tool

but i get this message as show here


also it don't delete the data complete after hit the clean button  to enter a new data


here the file
T_select_ALL.xlsm

I found another problem. In the V_OUT sheet, if I put a 3-digit number like 467 in column "B", it will ignore the 6 and find matches for 47. There are 3 things I can do:

1. Ignore that number
2. Make the results on the HIST_DA sheet be zero
3. When one of the 'Find' buttons on the V_OUT is clicked and the number doesn't have the correct number of digits, display an error message saying that the data is invalid.

Which one should I do?

Martin

When one of the 'Find' buttons on the V_OUT is clicked and the number doesn't have the correct number of digits, display an error message saying that the data is invalid.

I think this the best

That's what I thought you'd pick so I was ready for you:) I fixed another small problem too, the columns on the V_OUT sheet starting with column 'F' were not wide enough to see 4-digit numbers.
29080402c.xlsm

Well  you almost reading my mind  !! ;)

Martin

 can the sort in history be by the % column   descendant order  Please !


also im getting this message

can be fixed too Please !

I can sort it but please ask a new question.

I don't get the error you got. See the attached video.
2018-03-09_08-01-34.mp4

ok

great Job !!