We help IT Professionals succeed at work.
Comment
Watch Question

Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
OK, be back soon.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
;)
"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Try this.

I also made some changes to the Key Number and Sequence sheets so please examine them carefully.
29122585.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great  Job !
 Best Expert !
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
In Counts by Week you can accidentally select a week that's already in the history and as a result the same week can be in the history more than once like here.
2018-10-19_08-32-06.jpgWould you like me to modify the file so that that can't happen?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

Would you like me to modify the file so that that can't happen?

yes!
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
OK, here's the updated 2n file.
29122585a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
is working great