Stop Duplication of table

In Sheet QDS, when you press "Create QDS", It fetches names from MML sheet in Row 6, starting from Column V, and then go horizontally. And create copy of table with that name.

My problem is if I add new sheet, (that can be added from "customer" tab) And then press “create qds” button, then it duplicates table in qds sheet

I want to stop this duplication

I am attaching file here

I suggest you review your macro code, you never check if the table is there and just keep appending.
The worksheets more or less the same Worksheets(60.Copy after ... well which is (6) and yes the whole sheet is copied, just do a worksheets.add and then give the new sheet which is the active sheet the moment you add a name but check is the name already exists.
I say, 'back to the drawing board'

@keebellah. Thanks for reaponse. My wordings are wrong jn first message. I am talking about table in QDS sheet. My sheet already had 2 sheets named pm and asd. Now when you open QDS sheet press “Create QDS” button couple of times, you will see that table in that sheet created multiple times. What i want is if no new sheet exists aprat from pm and asd then pressing button shouldn't do nothing and if new sheet is added then it should add just 3rd table with new sheet name. I dont how to do this

Yu will have to check if the name already exists then skip and do the next one

Please Login or Register  to view this content.

The line marked red is the one that adds the new table

So what you have to do is check if the name exists in
So you create a loop starting with row 9 and lop in step 8 (because after 8 rows a new table begins , 9 is the first 9+8 = 17 is the next one, etc.)
Since it's your code you understand it better but this the idea.