Save Multiple worksheets into a new workbook and save the workbook

parvindar

New Member
Joined
Mar 21, 2019
Messages
1
Hi all,
Good day, I have tried to search in the forums for a vba code to

1) Save multiple worksheets into a new workbook
2) Save the new workbook in a particular folder macro free

However, there too many variations. Can you kindly point me to the right forum/direction or provide a code that i can use.

Thanks in advance.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

MarkReddell

Board Regular
Joined
Sep 1, 2011
Messages
205
Hello, I'm not for sure what u r trying to do. However, if you could combine all data by first making all W/S into tables, then creating a Pivot Table to combine all data.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,240
Messages
5,546,683
Members
410,754
Latest member
IainClover
Top