+ Reply to Thread
Results 1 to 1 of 1

Supplier Help

  1. #1
    Forum Contributor
    Join Date
    11-23-2004
    Location
    Bristol
    MS-Off Ver
    2016
    Posts
    225

    Supplier Help

    Hello all, I dont know if this is possible, I have a file with one worksheet called Suppliers, Quotes and Invoices. I can type up to 24 suppliers in a list and on the quotes form bring up one of those suppliers using the match & index code by entering S01 to S24. I was wondering if there was a way where I normally type in the code S01 to S24 in my quotes form, you simply float your mouse over the cell, and possibly a list could appear onscreen showing the S01 to S24 companies and addresses - then if highlighting one, the detail would be entered in the cell for you? I have put a very crude example of the type of thing I am asking for and would alter the vba to cover the exact range where the addresses are normally kept. Thanks
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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