VBA/Macro Course - 3 Ways to Create New Workbooks & Save and Close Them Using a Macro

Hi could you please help on how to move sheet 1 and sheet 2 simultaneously to another workbook since as you mentioned that array is not working. Thanks for this wonderful video❤

Really nice. You have explained so clearly

How would i copy multiple sheets to a new workbook? what would I adjust the Worksheets("sales1").copy code to?

This is really helpful. You made my day

This is great, thank you. How would I adjust the code to copy across more than one worksheet?

Hello thanks for the tutorial but just want to ask, what is the code for this scenario. I want to create a new workbook with the active sheet?. I have sheets from January - december if I want to create a new workbook for The active sheet February?

This is so useful thank you, Is it possible to only copy certain rows or even cells from a row into the new workbook?

Such a good video, so clear and nicely explained

If I wanted to copy multiple worksheets and move them to the same file, using the first method (which by the way this is the first one that I actually could follow after looking for an hour) how would I do that? For example, let's say there were 5 Sales tabs, and I wanted 1 and 2 on a new file labeled "PrimarySales.xlsx"

This is so useful. Thank you!

Nice tips. VBA is so useful and fun. Thanks for sharing :)) Thumbs up!!

When do u think the course will be available ?

The Power Of A Few Lines Of VBA Code!!Cool Tutorial...Thank You Sir :)