Consulting

Results 1 to 5 of 5

Thread: Referencing access data in excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Mentor
    Joined
    Aug 2011
    Posts
    353
    Location

    Referencing access data in excel

    I have an access table named cusips. The fields are cusip, maturity, coupon, and title. This table is linked to an excel sheet which contains the information for each cusip.

    See the attached excel document. In my attached excel doc, the first sheet is called data. This sheet is linked to my access table and houses all the data for each cusip. I enter the data here. The second sheet is called pulled from access. In cell B5, I would like to be able to enter a cusip (that exists in the access table) and when I enter that cusip in excel in that box, it pulls the info from access such as its title, maturity, and coupon. This is a really simple version of what I'm trying to get to so I'm making it very simple so you all can help me understand how to pull data.

    Thanks for the help!
    Attached Files Attached Files

Posting Permissions

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