+ Reply to Thread
Results 1 to 5 of 5

use a form to update and extract information from another excel document

  1. #1
    Registered User
    Join Date
    05-11-2019
    Location
    Leicester, England
    MS-Off Ver
    Pro Plus 2016
    Posts
    43

    use a form to update and extract information from another excel document

    I have 2 excel documents Data and Check.

    I would like to be able to use the forms in the check document to get the information I need without opening the data document

    Once I have that information if I change anything I would like it to update the data document.

    I hope this makes sense

    TIA

    Martin
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    371

    Re: use a form to update and extract information from another excel document

    Why can it not all be in one workbook ??????

  3. #3
    Registered User
    Join Date
    05-11-2019
    Location
    Leicester, England
    MS-Off Ver
    Pro Plus 2016
    Posts
    43

    Re: use a form to update and extract information from another excel document

    it can be arranged to be in all one document if I can prove it will work.

  4. #4
    Valued Forum Contributor
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    371

    Re: use a form to update and extract information from another excel document

    See the attached, is this what you are aiming at.
    I have made some changes to the layout of the 'Data' sheet.
    Un-merged merge cells as these can be bothersome when manipulating with VBA.
    Removed data validation as this is now done at 'form entry' stage, I have left the conditional formatting in place.
    So the 'Data' sheet now acts only as a flat database record.
    You will have to enter your 'issues' and 'checks' to suit your requirements in the respective sheets.
    These two sheets serve to load the combo-boxes they are 'elastic'(you can make additions)
    So each time the UserForm is activated the combo-boxes update.
    Hope this goes someway to what you are trying to achieve.
    torachan.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-11-2019
    Location
    Leicester, England
    MS-Off Ver
    Pro Plus 2016
    Posts
    43

    Re: use a form to update and extract information from another excel document

    that its brilliant thank you so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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