Moving data in new excel file

Heera

New Member
Joined
Feb 3, 2015
Messages
20
Hi Team,

I have a work book with 6-8 tabs which has data. I have 5-6 workbooks like this. Every day i need to copy and move one tab data to new worksheet and name the sheet for further purpose. It is taking lot of time.

Is there any short cut/macro where, in one click all tab sheet should copy and move into new excel file with same tab name ?

Your help is much appreciated.

Regards,
Heera
 
Last edited:

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,102,474
Messages
5,487,096
Members
407,577
Latest member
afonsomira

This Week's Hot Topics

Top