Results 1 to 23 of 23

Update workbook from another using upload button

Threaded View

  1. #1
    Registered User
    Join Date
    01-25-2017
    Location
    Worcester
    MS-Off Ver
    2016
    Posts
    93

    Update workbook from another using upload button

    I need a way of creating a form within a workbook which has multiple boxes to enter data into and for each box that data is entered into it corresponds to cells on another workbook which updates automatically when saved OR with an Update button on the form that forces it to update the 2nd workbook cells.
    Example are attached (unable to upload attachments for some reason so see images as examples). The form workbook will be filled and the data needs to be transfered onto the results spread sheet.

    Is this possible?

    Form.JPGresults.JPG
    Attached Files Attached Files
    Last edited by smudgers9; 11-23-2017 at 11:38 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to upload a file using a command button?
    By Brooksdt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2017, 07:33 PM
  2. Protected workbook, update filter with a button?
    By adamgm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2015, 03:32 PM
  3. How to create a button that upload pdf Object to the active excel spreadsheet?
    By Talk_4 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2015, 06:20 PM
  4. Open another excel file and copy data to sheet 2 while button upload is in sheeet 1
    By rflorentino in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2014, 08:47 PM
  5. Command Button to Update Workbook from External Workbook
    By QCBeauty in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2009, 07:19 AM
  6. Upload Workbook to FTP ???
    By Shaka215@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2006, 07:35 PM
  7. upload data from an excel worksheet to SQL W/ a command Button
    By cdneely in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2005, 12:20 PM

Tags for this Thread

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