• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 60
  • Last Modified:

selector to delete data

in this solution
 

HIST_DTA  

to select the rows to be delete
29079700a--1-.xlsm
0
ADRIANA P
Asked:
ADRIANA P
  • 13
  • 10
1 Solution
 
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 13
  • 10
Tackle projects and never again get stuck behind a technical roadblock.
Join Now