clean after the key number

ADRIANA P
ADRIANA P used Ask the Experts™
on
key number is 44
then when it repeat  after the row 48

need to delete the follows numbers
a1.PNG
with an button
Eliminated_repeat_data.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:
Try this.
29118765.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i get this Expert

b22.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
b33333.PNG
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:
ok i rename  DTA 2 to DTA sheet and is working
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Great JoB !

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

Commented:
I changed the name of the sheet while I was testing. Just double-click on the 'DTA (2)' tab and change it back to 'DTA".
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
How does the data get to the DTA sheet? Do you copy it from somewhere?

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