+ Reply to Thread
Results 1 to 13 of 13

Need help creating form that populates with data in row

  1. #1
    Registered User
    Join Date
    03-10-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    28

    Need help creating form that populates with data in row

    I've got a spreadsheet that contains company names and columns with specific information about each company. There is a different company in each row. I have a form (text bow) at the top of the spreadsheet that I would like to auto-populate with the row's information when the user clicks on a row. How do I go about doing this?
    Last edited by benji912; 03-10-2013 at 01:38 PM.

  2. #2
    Registered User
    Join Date
    03-02-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Need help creating form that populates with data in row

    Hi benji!
    Can you elaborate... maybe with an attachment...
    If I understand you right, it is possible doing this with VLOOKUP...
    Jason..

  3. #3
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Need help creating form that populates with data in row

    benji, welcome to the forum. Attaching a sample spreadsheet, showing your data layout, and clearly showing your expected results, would probably help a lot.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  4. #4
    Registered User
    Join Date
    03-10-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Need help creating form that populates with data in row

    where is the attach file button?

  5. #5
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Need help creating form that populates with data in row

    From here: http://www.excelforum.com/forum-rule...rum-rules.html

    Want to get your question answered quickly?.....

    ....Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

  6. #6
    Registered User
    Join Date
    03-10-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Need help creating form that populates with data in row

    I've looked through the website for 10 minutes and cannot find a the paper clip attachment. It's gone.

  7. #7
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Need help creating form that populates with data in row

    Whoops, maybe that's gone - I just copied and pasted from the forum rules.

    When replying, click the Go Advanced button. Scroll down to Additional Options, and in the Attachments section, click on the Manage Attachments button. From the pop-up window that opens, click the Add Files button, click Select Files, navigate to your file, select it, click the Upload Files button, then click on Done - that should do the trick.

    Hope this helps.

  8. #8
    Registered User
    Join Date
    03-10-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Need help creating form that populates with data in row

    I don't have excel on my home computer so I had to save it as a pdf. Basically what I want to be able to do, is when the user selects,for example,the cell with the company "AIG", the VOE text box would populate with this data:
    Name
    Company: AIG
    Position:
    Currently Employed:
    Phone #: 860-321-3531
    Verified: yp.com
    Verifier position:
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    03-02-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Need help creating form that populates with data in row

    Hi!
    I hope this is what you want....
    Jason.

    try this.xlsx

  10. #10
    Registered User
    Join Date
    03-10-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Need help creating form that populates with data in row

    Thanks, I can't view the spreadsheet because I don't have excel on my home computer. What function did you use?

  11. #11
    Registered User
    Join Date
    03-02-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Need help creating form that populates with data in row

    Vlookup.........

  12. #12
    Registered User
    Join Date
    03-10-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Need help creating form that populates with data in row

    Thanks for the help. I actually ended up using a combination of the index and match function. They worked perfectly for this function. =index(lookup array, match(reference, array, 0))

  13. #13
    Registered User
    Join Date
    03-02-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Need help creating form that populates with data in row

    Hi!
    I used a combination of Vlookup and Match...
    Jason....

+ 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