Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

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
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

Do you want the results in ORD order?
ADRIANA P

ASKER
Martin

 yes !
Martin Liss

Here are my results. Row 2922 (and probably others) are different than yours.
29118287.xlsm
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ADRIANA P

ASKER
still not working

yyy222.PNG
Martin Liss

Please pick a row and show me what the numbers should be.
ADRIANA P

ASKER
all 00  in the list should be show
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

Tell me a row number that is missing.
Martin Liss

I checked. Every cell in column 'A' that contains a zero has results in columns 'C' to 'J'.
ADRIANA P

ASKER
i dont see any change from the original file to the one you posted

still have the same error
Your help has saved me hundreds of hours of internet surfing.
fblack61
ADRIANA P

ASKER
this is how should be after fixed
zzzzz111111.PNG
ADRIANA P

ASKER
Here are my results. Row 2922 (and probably others) are different than yours.
29118287.xlsm


this file dont  work like that
Martin Liss

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
like i say   and show  up
Martin Liss

Are you trying to tell me that you get an error when you double-click a "00" cell?
ADRIANA P

ASKER
Are you trying to tell me that you get an error when you double-click a "00" cell?

Yes!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ADRIANA P

ASKER
Great JoB

! best expert
ADRIANA P

ASKER
why the file is not showing the colors by week ??zzz22222.PNG

as it was??
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
"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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
Working as needed

 Best Expert

alot of details  but you the best !
ADRIANA P

ASKER
still don't work
when i  double clik nothing happens

you did this before is nothing new
Martin Liss

Please don't make me guess. What exactly doesn't work.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ADRIANA P

ASKER
any number in column A
Martin Liss

You are still making me guess. What sheet? Double-click? I need complete information.
ADRIANA P

ASKER
sheet 1
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

You STILL haven't told me what is wrong.
ADRIANA P

ASKER
asd.PNG
ADRIANA P

ASKER
i have to repeat all over
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ADRIANA P

ASKER
can you please test the file i upload

2n_fix_00_.xlsm
ADRIANA P

ASKER
i have just problem with 00 but the others num  was working good

that the reason i mention just the 00
Martin Liss

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
Martin

the file i upload worked with any num

then now not

why ??
ADRIANA P

ASKER
the only correction needed was with 00

but i don't want the others as was
ADRIANA P

ASKER
and eliminated the arrows
you already did
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ADRIANA P

ASKER
but i don't want to change the others as it  was upload at first
to be fixed
Martin Liss

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.
ADRIANA P

ASKER
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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
Great JOb

working as needed