Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying Data from an input form to a worksheet (MS

    Dear Excel experts,

    From a worksheet called "Ports" with a control toolbox combo box a "Port" is selected from the drop down selection and the relevant information is displayed in the rows below it starting at J18. This information is located in the same workbook in a worksheet called DataSheet. When a new port is added to the list all the information has to be entered into the DataSheet. I would like a macro that would open up a data form where all that information could be entered and then it should paste that data into the correct row below the last entry in the DataSheet. The data is stored in the columns starting in row 187:

    The data displayed in the Port Sheet is the same as below (Port...Region...Client...Local Contact...etc)

    Port selected from Combo box) Column B (origin of information DataSheet! B187 : B 300)
    Region: Column C (origin of information DataSheet! B187 : B 300)
    Client : Column D (origin of information DataSheet! B187 : B 300)
    Local contact Detail: Column E (origin of information DataSheet! B187 : B 300)
    Local Name: Column F (origin of information DataSheet! B187 : B 300)
    Phone direct: Column G (origin of information DataSheet! B187 : B 300)
    Mobile : Column H (origin of information DataSheet! B187 : B 300)
    Fax : Column I (origin of information DataSheet! B187 : B 300)
    A/H: Column J (origin of information DataSheet! B187 : B 300)
    E-Mail : Column K (origin of information DataSheet! B187 : B 300)
    Supplier: Column L (origin of information DataSheet! B187 : B 300)
    Commercial Contact: Column M (origin of information DataSheet! B187 : B 300)

    If a new port is added the data should be copied under the last occupied row.



    Any help or suggestions very much appreciated. Thank you all.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying Data from an input form to a worksheet (MS

    Excel has a simple built-in form, under Data | Form.
    John Walkenbach has a free add-in that provides an enhanced version: J-Walk Enhanced Data Form v2.

Posting Permissions

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