Simple VBA Script to Merge/Combine Excel Sheets into One
PS: As of now the data copied from the sheets for merging are pasted as text/values only, so no formulas are copied, formatting stays same.
- Make sure to download the Zipped Release from here - DOWNLOAD
- Import the xcelsheetsmergerv1.1.frm Form into your Excel workbook's Visual Basic Code Editor.
- xcelsheetsmergerv1.1.frm will appear as a Form in the Project Explorer(You can turn on Project Explorer from View if it's not there).
- Double Click on xcelsheetsmergerv1.1.frm
- Click the Play button or Run(You can use shortcut F5 to Run as well.)
If you don't have Macro's enabled first enable the Developer Tab:
Go to File –> Options.
In the Excel Options dialogue box, click on Customize Ribbon in the left pane. It will show the Customize the Ribbon options on the right.
On the right, within the Main Tabs pane, check the Developer option.
Click OK.
Future Feature Plans:
- Come up with a better system to flexibly offset rows.
- Option to enable and disable formula being pasted.
- Create a two pane side by side list UI input system to select the sheets to skip/merge to make it more intuitive and easy.(like add/remove system)