This tip will show you how to copy an Excel Macro into your workbook or spreadsheet. You will learn the different locations that you might install the macro as well as what you need to make sure is included in the macro for it to work. First - Every macro must start and end like the example below:

Sub The_Name_of_The_Macro()

The code for the macro goes here.

End Sub

Every macro in Excel must start with "Sub" and end with "End Sub." The name of the macro must have an open and closed parenthesis right after it. You can name the macro anything that you want but you should make it describe the function of the macro. All of the actual code for the macro comes after the name of the macro and before "End Sub." ...

This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and worksheet. When the macro runs, it prompts you to select which excel files from your computer you would like to combine and, once you select them and press ok, this macro will pull data from pre-specified worksheets in the selected workbooks and then combine the data onto one worksheet within a new excel workbook. This works quickly and easily and does not require the hard-coding of file names into the macro.

Note: This macro goes into a Module. Also, you will need to change some cell references and worksheet references if you want the macro to work for your specific needs.

Change the number in this line of code With mybook.Worksheets(1) to choose which worksheet you want data to be copied from in the workbook. 1 means the first sheet and 2 the second sheet etc. ...