3N to 0DIGIT

ADRIANA P
ADRIANA P used Ask the Experts™
on
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
When I was testing the 3N modification I found a problem that affected both the 2N and 3N so I'm attaching  both here. The problem was that if you looked for the number that's in column 'X' row 2 of the DTA sheet, you'd get an error so when testing the new 3N, make sure you search for number 65.
2N.xlsm
29123076.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
You make it look easy

Best EXpert !
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

3N
a93.PNG
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
It only happens for 65 and I'm sure I can fix that.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
It was a simple fix. I also made it so that when the weeks or the 0 number list shows up you don't have to click the OK button after you've made your selections, you can now just press Return.
29123076a.xlsm
2N.xlsm

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