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

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

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,109,453
Messages
5,528,875
Members
409,843
Latest member
akostaki
Top