Excel Solutions

How to Batch Delete Multiple Unwanted or Unused Files with Excel VBA

There might be several unwanted and unused files eating your disk space. Cleaning these files might be a huge task. With excel, you can easily find such unused files and delete them instantly to free disk space. Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Let's Prepare the GUI Remove unwanted sheets from the workbook and rename the Sheet 1 as GUI and...

Read more »

How to Batch Delete Columns in Multiple Excel Workbooks

It is very common to see people saving confidential data in Excel workbooks. When these workbooks have to be shared with other colleagues or friends, manual deletion is the only option available. However, with this article, you will learn how to quickly delete confidential columns or unwanted columns from multiple workbooks. Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the...

Read more »

How to Easily Move Worksheets from One Workbook to Another with Excel VBA

If you want to move sheets from one workbook to other workbooks, follow this article and create your own tool to automate the task. Quickly select necessary sheets and copy it swiftly to all other target workbooks Let's Prepare the GUI This tool needs a single sheet in the macro-enabled workbook. Rename the Sheet 1 in the workbook as "ControlPanel". As shown in the image, create necessary fields to allow the user to pick the source workbook, display sheets from the selected workbook and an...

Read more »