asked on clean after the key number
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
then when it repeat after the row 48
need to delete the follows numbers
with an button
Eliminated_repeat_data.xlsm
VBAMicrosoft ExcelMicrosoft Office
Last Comment
Martin Liss
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
i get this Expert
![b22.PNG]()
ASKER
ASKER
ok i rename DTA 2 to DTA sheet and is working
ASKER
Great JoB !
Best Expert!!
Best Expert!!
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".
How does the data get to the DTA sheet? Do you copy it from somewhere?