We help IT Professionals succeed at work.

clean after the key number

115 Views
Last Modified: 2018-09-19
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

Protect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
i get this Expert

b22.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
b33333.PNG
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 LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
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 LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

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