Create new sheets based on condition

[[email protected]]

Hi All,

I need a macro if the given sheets(more than one sheet) are not exist in the workbook then same to be create in the workbook.

kindly share the macro code.

Regards,

Prabhu

[Kenneth Hobson]

Please Login or Register  to view this content.

[[email protected]]

Hi,

it is searching the sheet but i need to create sheet if the mentioned sheet is not available.

Example i am looking for sheets1,sheet2,sheet3 and sheet 4. if the sheet3&4 is not in the workbook then it should create sheet 3 and sheet 4.

kindly do the needful