Delete Duplicate Rows

[myobreportguru]

I have a workbook that have several worksheets. In the first worksheet there are duplicate rows 820 to 827 and the second worksheet the duplicate rows are 288 and 289. I want to delete those rows. The code needs to be added to the existing code to extend the formulas in Col J so delete the rows and then extend the formula and the same thing for all worksheets. Only the first and second worksheets have duplicates at the moment. In the future data will be added to each worksheet which will definitely have duplicates so that will need to be deleted as well. I would appreciate any help. Thanks in advance.

Regards
John

[Winon]

Hello myobreportguru,

First of all, Do Not Use Merged Cells, it messes around with Automation.

On Sheet 7 in Rows 808 to 810 please change your merged cells as demonstrated in the attachment.

To remove duplicates from all sheets, you could change your Code as below;

Please Login or Register  to view this content.

I am not sure if you wanted a Button attached to the NoDups Code.


Regards.

[myobreportguru]

Thanks for your help. I put the code in a button on sheet 1. However there were no rows deleted, sheet 1 or sheet 2. I hope I understood you correctly.

Regards
John

[myobreportguru]

I meant to send the file back.

[Winon]

Hi myobreportguru,

In that case we will have to work with Columns from A to i.

Please Change the Code to;

Please Login or Register  to view this content.

I see you have marked the Thread as Solved. How did you solve it, if I may?

Regards.

[myobreportguru]

I'm sorry Winon. I thought you had clocked off and I'm in a hurry. I don't know if I can do this but I marked it as solved and went and put it in the commercial posts. Why don't you take it up on the commercial post and get some funds for your effort.

Regards
John