I have a payroll workbook that I'm working on. Every two weeks I add another worksheet by copying the template. Is there a way that my total worksheet could be continually updated to reflect the new worksheet, preferably without using a vba.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.