adjust file to find 00

ADRIANA P
ADRIANA P used Ask the Experts™
on
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
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:
Do you want the results in ORD order?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

 yes !
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

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

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
still not working

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

Commented:
Please pick a row and show me what the numbers should be.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
all 00  in the list should be show
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Tell me a row number that is missing.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

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

Author

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

still have the same error
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
this is how should be after fixed
zzzzz111111.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

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


this file dont  work like that
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

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

Author

Commented:
like i say   and show  up
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

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

Author

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

Yes!
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
I think this fixes the problem. I also removed the arrows.
29118287a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great JoB

! best expert
ADRIANA PACCOUNTING ASSISTANT

Author

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

as it was??
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
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
ADRIANA PACCOUNTING ASSISTANT

Author

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
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Color me embarrassed.
29118287c.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Working as needed

 Best Expert

alot of details  but you the best !
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
still don't work
when i  double clik nothing happens

you did this before is nothing new
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Please don't make me guess. What exactly doesn't work.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
any number in column A
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You are still making me guess. What sheet? Double-click? I need complete information.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
sheet 1
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You STILL haven't told me what is wrong.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
asd.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i have to repeat all over
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
can you please test the file i upload

2n_fix_00_.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

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

that the reason i mention just the 00
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

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

Author

Commented:
Martin

the file i upload worked with any num

then now not

why ??
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
the only correction needed was with 00

but i don't want the others as was
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
and eliminated the arrows
you already did
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
but i don't want to change the others as it  was upload at first
to be fixed
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

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

Author

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
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
In this version click the 'Find Number' button.
29118287d.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great JOb

working as needed

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