Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag 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

User generated image2n_fix_00_.xlsm
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Do you want the results in ORD order?
Avatar of ADRIANA P

ASKER

Martin

 yes !
Here are my results. Row 2922 (and probably others) are different than yours.
29118287.xlsm
still not working

User generated image
Please pick a row and show me what the numbers should be.
all 00  in the list should be show
Tell me a row number that is missing.
I checked. Every cell in column 'A' that contains a zero has results in columns 'C' to 'J'.
i dont see any change from the original file to the one you posted

still have the same error
this is how should be after fixed
User generated image
Here are my results. Row 2922 (and probably others) are different than yours.
29118287.xlsm


this file dont  work like that
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.
like i say   and show  up
Are you trying to tell me that you get an error when you double-click a "00" cell?
Are you trying to tell me that you get an error when you double-click a "00" cell?

Yes!
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great JoB

! best expert
why the file is not showing the colors by week ??User generated image

as it was??
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Working as needed

 Best Expert

alot of details  but you the best !
still don't work
when i  double clik nothing happens

you did this before is nothing new
Please don't make me guess. What exactly doesn't work.
any number in column A
You are still making me guess. What sheet? Double-click? I need complete information.
sheet 1
You STILL haven't told me what is wrong.
User generated image
i have to repeat all over
can you please test the file i upload

2n_fix_00_.xlsm
i have just problem with 00 but the others num  was working good

that the reason i mention just the 00
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.
Martin

the file i upload worked with any num

then now not

why ??
the only correction needed was with 00

but i don't want the others as was
and eliminated the arrows
you already did
but i don't want to change the others as it  was upload at first
to be fixed
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.
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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great JOb

working as needed