show up list of numbers

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
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:
OK, I think I understand what you want.
1
Martin LissOlder than dirtCommented:
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?
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
Determine the Perfect Price for Your IT Services

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

Martin LissOlder than dirtCommented:
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?
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
Martin LissOlder than dirtCommented:
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.
0
Martin LissOlder than dirtCommented:
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

1
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
Martin LissOlder than dirtCommented:
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?
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
This way the list can be work

not just one by one
0
Martin LissOlder than dirtCommented:
I'm sorry Adriana, but I don't think I can help you with this.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Ok Martin
0
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
@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?
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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 )
0
Martin LissOlder than dirtCommented:
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
1
ADRIANA PACCOUNTING ASSISTANTAuthor 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!!
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
May i ask  

when is 100 %

the color  can be  red color??
0
Martin LissOlder than dirtCommented:
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
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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.