How to Write a Macro That Copies Excel Data Into a Word Document

You can write a macro to help you with documents in Microsoft Word and files in other programs. If you’re working on a spreadsheet that you paste repeatedly into Word, save yourself time by creating a macro for it instead. Macros help you record your work or actions. You can minimize your Word file, then open the Excel spreadsheet you want to copy.

Instructions

    • 1

      Go to Microsoft Word and open a new or existing document.

    • 2

      Click on "Tools," "Macro" and "Record New Macro" in the toolbar. Name your macro, choose the location where you'd like to store it (under "Store macro in") and click "OK."

    • 3

      Begin recording your actions for the macro by minimizing your Word document window and going to Microsoft Excel.

    • 4

      Open the spreadsheet that contains the data you need and select the areas you want to copy. To copy it, click on "Edit" and "Copy" (shortcut: "Ctrl"-"C").

    • 5

      Minimize the Excel file and return to the MS Word file where you're recording the macro.

    • 6

      Place your cursor in the area of your document where you want to paste the data. Then click on "Edit" and "Paste Special" in the toolbar. Choose “Microsoft Office Excel Worksheet Option” in the "Paste Special" dialog box and click “OK.” The data will be pasted into Word.

    • 7

      Press the "Stop Recording" button in the "Stop Recording" toolbar for the macro. You can now use the macro in Word.

Related Searches

References

  • Photo Credit Jupiterimages/Photos.com/Getty Images

You May Also Like

Related Ads

Check It Out

Prep for Black Friday Checklist [Infographic]