adjust file to find 00

when i hit 00 to get the results in sheet 2

is not working properly and need eliminated the arrows too

x33333.PNG2n_fix_00_.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:
Do you want the results in ORD order?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

 yes !
0
Martin LissOlder than dirtCommented:
Here are my results. Row 2922 (and probably others) are different than yours.
29118287.xlsm
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!

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
still not working

yyy222.PNG
0
Martin LissOlder than dirtCommented:
Please pick a row and show me what the numbers should be.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
all 00  in the list should be show
0
Martin LissOlder than dirtCommented:
Tell me a row number that is missing.
0
Martin LissOlder than dirtCommented:
I checked. Every cell in column 'A' that contains a zero has results in columns 'C' to 'J'.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
i dont see any change from the original file to the one you posted

still have the same error
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
this is how should be after fixed
zzzzz111111.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Here are my results. Row 2922 (and probably others) are different than yours.
29118287.xlsm


this file dont  work like that
0
Martin LissOlder than dirtCommented:
still have the same error
You haven't told me what the error is. All you said is that "all 00  in the list should be show". Please give me more information. Are you saying that Sheet1 is wrong or is it Sheet2 that's wrong? If it's Sheet2, tell me what's wrong with it.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
like i say   and show  up
0
Martin LissOlder than dirtCommented:
Are you trying to tell me that you get an error when you double-click a "00" cell?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Are you trying to tell me that you get an error when you double-click a "00" cell?

Yes!
0
Martin LissOlder than dirtCommented:
I think this fixes the problem. I also removed the arrows.
29118287a.xlsm
0

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

! best expert
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
why the file is not showing the colors by week ??zzz22222.PNG

as it was??
0
Martin LissOlder than dirtCommented:
I've made what I think are a couple of improvements.

In the previous version of this workbook, no matter which “00” was double-clicked, the results on Sheet2 were always the same, so in this version I added a new button called ‘Find “00”’ ‘ which will make it easier. I also changed the name of the middle button so that it describes better what it does. I can change it back if you want me to.

En la versión anterior de este libro de trabajo, sin importar en qué "00" se hizo doble clic, los resultados en Sheet2 siempre fueron los mismos, así que en esta versión agregué un nuevo botón llamado 'Find' 00 '' 'que facilitará . También cambié el nombre del botón del medio para que describa mejor lo que hace. Puedo cambiarlo si quieres que lo haga.
29118287b.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
"I can change it back if you want me to."

great job !!

is good to me


but need keep the color track as it was Martin
0
Martin LissOlder than dirtCommented:
Color me embarrassed.
29118287c.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Working as needed

 Best Expert

alot of details  but you the best !
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
still don't work
when i  double clik nothing happens

you did this before is nothing new
0
Martin LissOlder than dirtCommented:
Please don't make me guess. What exactly doesn't work.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
any number in column A
0
Martin LissOlder than dirtCommented:
You are still making me guess. What sheet? Double-click? I need complete information.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
sheet 1
0
Martin LissOlder than dirtCommented:
You STILL haven't told me what is wrong.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
asd.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
i have to repeat all over
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
can you please test the file i upload

2n_fix_00_.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
i have just problem with 00 but the others num  was working good

that the reason i mention just the 00
0
Martin LissOlder than dirtCommented:
THAT'S the kind of information that stops me from having to guess.

Instead of double-clicking, just click the new  ‘Find “00”’ button.
There are no more arrows anywhere.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

the file i upload worked with any num

then now not

why ??
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
the only correction needed was with 00

but i don't want the others as was
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
and eliminated the arrows
you already did
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
but i don't want to change the others as it  was upload at first
to be fixed
0
Martin LissOlder than dirtCommented:
In some of your workbooks, only double-clicking "00" did anything so that's what I did for this one, and since you never said something like "When I double-click ANY number in columns 'A' of Sheet1, I need to see data in Sheet2", I had no idea that that was what you wanted.

I'll make the change, but please don't give me any more points in this question.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
When I double-click ANY number in columns 'A' of Sheet1, I need to see data in Sheet2", I had no idea that that was what you wanted

sorry  Best Expert

as the file is working good as needed

  but  not when an 00 num have to be
0
Martin LissOlder than dirtCommented:
In this version click the 'Find Number' button.
29118287d.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great JOb

working as needed
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
VBA

From novice to tech pro — start learning today.