In this article we will show you how to add a sheet to an Excel workbook using VBA. There are 2 different methods detailed below in order to do this.

In case you work in one Excel workbook that you'd like to move to another one, there is a simple solution that doesn't require knowing macros or VBA codes – it can be done in a few simple clicks. Read ...

How to generate a list of hyperlinks in Excel It’s not unusual for a complex workbook to include a list of hyperlinks to each sheet in the workbook.

Why You Should Add a Table of Contents to Excel What would you do if you had hundreds of sheets in an Excel workbook and needed to find a specific one for updating or modifying data? Searching ...

You don't have to add a header to every Excel worksheet individually when you can group them first. Adding a header (or footer) to an Excel sheet is a simple task using Excel’s Page Layout view.