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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

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,471
Messages
5,548,218
Members
410,824
Latest member
Bobmn4
Top