Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to populate workbook table from user input in another workbook?

  1. #1
    New Member
    Join Date
    Oct 2015
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question How to populate workbook table from user input in another workbook?

    Hey everybody,

    I'm trying to keep a master list of product data that will automatically populate based on user input.

    The way things are currently set up, a user fills out a worksheet with product data (serial number, calibration information, customer, etc.) and a VBA coded button formats the name of the form by date and serial number, and sends it to another folder, retaining the original template. We then have to manually enter all of this information again into a second workbook (master list) of all products and data.

    Is there a way to have the information input cells automatically get sent to the master? I would like to retain the structure of the original worksheet as much as possible.

    Thanks in advance,

    Will do my best to answer all questions.

    Software:
    Office 2010
    W7 x64

  2. #2
    New Member
    Join Date
    Oct 2015
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to populate workbook table from user input in another workbook?

    Found how to do it if anyone was interested:

    How to Transfer Data from One Excel Workbook to Another Automatically | Excel VBA Training Videos

    Does anyone know a way to do it in the background? (Without opening the second workbook)

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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