show up list of numbers

OK, I think I understand what you want.

If you look for two numbers (like 219 and 813) do you want both of the results to be on the same line in the history sheet or do you want one line for 219 and another line for 813?

LIST_DTA  sheet

could be the input for the list

or similar  to this

so in column B the list of number can grown or shrink as needed

That didn't answer my question.

In the past when you wanted to look for more than one number the 'Find 3' button for example would let you enter something like  219, 813. Would that be OK?

Martin

If you look for two numbers (like 219 and 813) do you want both of the results to be on the same line in the history sheet or do you wantIf you look for two numbers (like 219 and 813) do you want both of the results to be on the same line in the history sheet or do you want one line for 219 and another line for 813?


 one line for 219 and another line for 813 should be the correct

Currently, after you click any of the 'Find' buttons, the results of that Find for that one number are displayed on the V_OUT sheet, and then it's up to you if you want to click the 'Move to History' button.  If you wanted to look for more than one number at the same time there are at least two problems:
1) There's no room for the results for more than one number on the V_OUT sheet, and
2) If there were room, how would you decide which ones to move to history?

My suggestion is that you don't change the program.

BTW, I found a problem with the way the '%' amounts on the HIST_DTA sheet are calculated. To fix that problem go to Module1 and replace the UpdateHistory sub with this code

Sub UpdateHistory()
Dim wsH As Worksheet
Dim wsV As Worksheet
Dim lngNextRow As Long

Set wsV = Sheets("V_OUT")
Set wsH = Sheets("HIST_DTA")

With wsH
    lngNextRow = .Range("A1048576").End(xlUp).Row + 1
    .Cells(lngNextRow, "A") = wsV.Range("A4")
    .Cells(lngNextRow, "B") = wsV.Range("B6")
    .Cells(lngNextRow, "D") = wsV.Range("B1")
    .Cells(lngNextRow, "E") = wsV.Range("A6")
    .Cells(lngNextRow, "C") = Format(wsH.Range("E" & lngNextRow) / wsH.Range("D" & lngNextRow) * 100, "00.00")
    .Cells(lngNextRow, "C").Interior.Color = vbYellow
    ' Get rid of green triangle
    .Cells(lngNextRow, "C").Errors(xlNumberAsText).Ignore = True

    wsV.Range(Cells(6, "C"), Cells(6, wsV.UsedRange.Columns.Count)).Copy Destination:=.Cells(lngNextRow, "G")

End With
End Sub

Select allOpen in new window

Martin  

Good question

1- There's no room for the results for more than one number on the V_OUT sheet, and

V_OUT have the place to the data to be work with

I don't understand your answer. How does it apply to my two problems?

1) There's no room for the results for more than one number on the V_OUT sheet, and
2) If there were room, how would you decide which ones to move to history?

Martin

i ppost file 234567899.xlsm  

just to explain the fucntionality

but the file to put the code works on
is this one
90876765334.xlsx

in this file
we can take the data from V_OUT sheet


then


the LIST_DTA  sheet column B is where the list of numbers to analyze are
Buttons  with the find 1  find 2 find 3 wityh the code goes in this sheet ( not V_OUT data sheet , beacuse this an list not one by one)



they goes after analyze to the   HIST_DATA  sheet

This way the list can be work

not just one by one

I'm sorry Adriana, but I don't think I can help you with this.

Ok Martin

@Adriana,

to be frank, I'm not sure about your requirement as I didn't track your Excel project development progress

so, what is working right now and what is not? i will try to understand your requirements...

with find 3   find 2 find 1
but need
enter an list of numbers not one by one
then the output of the multiple list of numbers

can you elaborate further?

Ryan Chong

Thanks


1- I have this file  file working as needed

2- when i hit find 1  or  find 2 or find 3

V_OUT sheet

this  file look for column by column  as needed

then it show the ocurrence

234567899.xlsm

Ryan Chong

but this works one by one

I just enter one number ( find 1 or find 2 or find 3)

after the look for number  (find 1  or find 2 or find 3 )

i decide to move to  the  (have button to  move call  move to history)

HIST_DATA sheet  to compare all the one by one  look for i did

Ryan Chong

but in the real life situation  

i have an list of numbers  (not one by one as it take a lot of time to work with )

so i need create an more practical ea to work with the list of numbers

then

this file is more practical way to work

1- data will be  on V_OUT

2- the list of numbers will be in column B in LIST_DTA


3- after the look for ( each number in the list as needed) it shows  in HIST_DTA sheet

90876765334.xlsx

I clarify

when  a find 1 look for is made

the ouput will be just of  find 1  

i mean i wont mix find 1  find 2 or find 3  output data (or search )

Try this. It's a bit different then your requirements in that there is no LIST_DTA sheet.

Would you like to be asked "Are you sure?" when the 'Clean Data' buttons on sheets V_OUT and HIST_DTA are clicked?
29079700.xlsm

Martin

Would you like to be asked "Are you sure?" when the 'Clean Data' buttons on sheets V_OUT and HIST_DTA are clicked?

yes sure!!

May i ask  

when is 100 %

the color  can be  red color??

Great Job !