ExcelBanter - View Single Post - Merging Worksheets together into Master Worksheet

marcia2026

"Ron de Bruin" wrote:

Hi marcia2026

For others this is the code page
http://www.rondebruin.nl/copy2.htm

If you want to use the code in all your workbooks you can copy it in your personal.xls(b)

1) Select the PERSONAL.XLS(B) in the project window and click on the + before it
2) Then click on the + before Modules
3) Double click on Module1 to open the code window on the right
4) We copy/paste the macro and function in this module.
5) Now use Ctrl-s or FileSave in the VBA editor to save the PERSONAL.XLS.
6) We use Alt€“q to go back to Excel or use "File Close and Return to Microsoft Excel".
7) You can run the macro then with Alt-F8 or ToolsMacro€¦Macros / Developer tabMacros

See also if you not have this file
http://www.rondebruin.nl/personal.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"marcia2026" wrote in message ...
I am trying to merge all worksheets from the workbook into one master sheet.
I have downloaded Ron's example from his webpage and it works great in his
test file. But when I close that file and bring up the workbook that I want
to run the macro in, it has disappeared. How do I get the macro into my
personal file, so that I can use in whenever I want?

thanks bunches, I am very new to this.
marcia