Posts by sv651

You might try the free auditing add-in here: http://www.xl-logic.com/pages/explode.html

Not sure if it will do exactly what you want, but hopefully it will help.

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!