show up list of numbers

ADRIANA P
ADRIANA P used Ask the Experts™
on
have this file working great

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

bbbsr4321.PNG
 

be show in HIST_DTA  sheet
234567899.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
OK, I think I understand what you want.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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

list_sheet.PNG
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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

Open in new window

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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

1234556221.PNG
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
This way the list can be work

not just one by one
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I'm sorry Adriana, but I don't think I can help you with this.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Ok Martin
Ryan ChongSoftware Team Lead

Commented:
@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?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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

1234556221.PNG234567899.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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

bbbsr4321.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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

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

asdeqwr.PNG90876765334.xlsx
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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 )
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
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!!
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
May i ask  

when is 100 %

the color  can be  red color??
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great Job !

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial