+ Reply to Thread
Results 1 to 1 of 1

Macro to that pulls data from Userform/spreadsheet and transfers to Word Template

  1. #1
    Registered User
    Join Date
    07-15-2016
    Location
    Wisconsin
    MS-Off Ver
    2010
    Posts
    80

    Macro to that pulls data from Userform/spreadsheet and transfers to Word Template

    Hi everyone,

    Attached are the Excel Userform/spreadsheet and the Word Template.

    So far what I have created is when we get visitors at my work, they will sign in using the Userform, the data will then be added to the Visitor Log Tab, and will look in the ITAR Forms tab to see if there name is already in the spreadsheet. If not it will pop up another Userform for them to fill out, which will then add the data to the ITAR Forms table when they hit submit, and will also add them to the Visitor log tab.

    What I am looking for is once they hit either Sign In or Submit, the Name, Date, Badge Number, Contact, and the Level, will transfer to the Word template and print out a label for our visitors (I have already added bookmarks added to Word).
    Name, Date, Badge Number, and Contact will be from the Visitor Log tab, Level will be from the ITAR Forms tab

    Hopefully someone can help me with this!

    Thank you in advance.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Import Data to Word UserForm from Excel spreadsheet
    By phiko73 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2019, 05:32 PM
  2. [SOLVED] Export UserForm CheckBox data to Word-template
    By ODeveloper in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-21-2015, 05:25 AM
  3. Send Data From Excel Userform to Microsoft Word Document Template
    By t0mps in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-09-2014, 03:18 PM
  4. Replies: 1
    Last Post: 06-04-2014, 03:29 PM
  5. Replies: 0
    Last Post: 06-04-2014, 03:16 PM
  6. Master Spreadsheet Pulls Variable File Name Data
    By thesonofdarwin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2014, 06:43 AM
  7. Macro that pulls data from one spreadsheet to another
    By EOrlovskis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2012, 02:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1