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
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: