VBA loop to insert and delete worksheets in a specific sheet within a list

I can't figure it out how to delete any worksheet that is not the specific sheet in a list, for example, column A's cells match the same names with worksheet's names; and how to insert a new worksheet for column A's cells on the list that does not currently have its own worksheet. Conditionally, the specific sheet won't be deleted. Please help. It gonna be loop for every cell in Column A.

If I understood your query correctly then you have a list of worksheet name in Column A and you want to match them with worksheet name on same workbook..

.if name doesn't exist but sheet exist then you want to delete that sheet and if name is available in column A and sheet doesn't then you want to create a worksheet with that name?

Please Login or Register  to view this content.

Originally Posted by BS Singh

If I understood your query correctly then you have a list of worksheet name in Column A and you want to match them with worksheet name on same workbook..

.if name doesn't exist but sheet exist then you want to delete that sheet and if name is available in column A and sheet doesn't then you want to create a worksheet with that name?

Yes, exactly.

Originally Posted by stnkynts

Please Login or Register  to view this content.

Thank you so much. It works perfectly. But is it loop function?

But is it loop function?

It incorporates 2 loops