after keynum eliminated the follows

ADRIANA P
ADRIANA P used Ask the Experts™
on
eliminated the follows after  the repeat key number repeat

as we did in https://www.experts-exchange.com/questions/29119277/3N-eliminated-repeat-after-keynumber.html

but this case for 4N

here the file
4n_to_create_eliminated_repeat.xlsm
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:
I also hid the 'Template' sheet since it is only used in the code.
29119471.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
You make it look easy.

Great Expert !

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