selector to delete data

in this solution
 

HIST_DTA  

to select the rows to be delete
29079700a--1-.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
Would you like a new column "F" that indicates which rows you want to delete?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Would you like a new column "F" that indicates which rows you want to delete?

Yes Martin !
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Column F is an great place because
 it don't have any data
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Martin LissOlder than dirtCommented:
Here you go. I also added a yellow to red color scheme in column "C" instead of just yellow or red. Let me know if that's OK.
29080402.xlsm
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
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.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Is an Great Solution !!

Best Expert !
0
Martin LissOlder than dirtCommented:
You sent me a message that this isn't working correctly. Please describe what's wrong.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

the solution is showing in history
some incomplete data

for example i do this

put this data as show here
a1.PNG

this data goes until column
a2.PNG

here the total columns and count
a3.PNG

but

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

a4.PNG

here the file with the data  on


Please Best Expert help on this !
To_look_for_f1_f2_f3.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
from column F to KT in this sample
a2.PNG
0
Martin LissOlder than dirtCommented:
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.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
muchas  columnas seran utilizadas  

siempre con datos

"many columns will always be used with data"
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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
0
Martin LissOlder than dirtCommented:
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
1
Martin LissOlder than dirtCommented:
This version does NOT clear the previous results. Use whichever one you want.
29080402b.xlsm
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great JOB !!
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Triying to work with this tool

but i get this message as show here

a8.PNG
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
0
Martin LissOlder than dirtCommented:
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?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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
0
Martin LissOlder than dirtCommented:
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
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Well  you almost reading my mind  !! ;)

Martin

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

a11.PNG
also im getting this message

can be fixed too Please !

a10.PNG
0
Martin LissOlder than dirtCommented:
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
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ok

great Job !!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.