I have 5 worksheets, each with about 3000 rows & 50 columns of (contiguous) data, that I would like to copy to a new workbook.
I'll be doing this on a regular basis & am wondering if there's a super-efficient VBA-based approach to programmatically create a new workbook & transfer the contents of my 5 sheets to 5 sheets in the new workbook.
Right now I'm planning on using the Copy method along with either:
1./ Set newBook = Workbooks.Add; or,
2./ Set ExcelSheet = CreateObject("Excel.Sheet")
Any guidance appreciated!