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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

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,362
Messages
5,547,473
Members
410,797
Latest member
mlfuson
Top