tabs into new worksheet

[Sant]

Hi Expert,

in one excel file there are 15 tabs with unique name to it.

requirement is ;
1. Convert these 15 tabs into new worksheet
2. Name for each NEW excel file should be of that of 'tab name"

Can you please help ?

thanks a lot in advance,
Sant.

[Leith Ross]

Hello Sant,

Welcome to the Forum!

Do you want to create 15 new workbooks (Excel files) named for each tab in your open workbook?

[Sant]

Hello Leith Ross,

thanks a lot.

Yes, I want to create 15 new workbooks (Excel files).

your help is appreciated here.

Regards,
Sant

[Sant]

I have attached a sample excel file with 3 tabs in it.

thanks,
Sant

[ravishankar]

Hi
try the macro in the attached workbook
Ravi

[Sant]

thanks Ravi.

Seems it is working.

But the data is not getting copied from the tab. Can you please check again? Am I doing some mistake ?

I am attaching sheet 3 tabs with micro name COPY.

thanks again...

Regards,
Santosh

[ravishankar]

Hi
Now the macro is working as expected.
Ravi

[Sant]

thanks Ravi....working as expected.

Regards,