Results 1 to 8 of 8

Creating form notes using drop downs ?

Threaded View

  1. #1
    Registered User
    Join Date
    08-12-2019
    Location
    United States
    MS-Off Ver
    32 Bit (?)
    Posts
    4

    Creating form notes using drop downs ?

    (I'm sorry if this isn't the correct forum; I don't actually know how I'd start, so I'm not sure if this would be a formula & function or something else.)

    I work in a position where I work w/ multiple companies, and I often have to leave the same or similar notes on accounts, and I'm trying to figure out if there's an excel way to do that?

    For example:

    CompanyA - PhoneNumber1
    CompanyB - PhoneNumber2
    CompanyC - PhoneNumber3

    Note example: Reached out to customer to ask if customer wanted Blue Teapots, asked customer to call us back at PhoneNumber

    I'd like a way to have the Company names in a drop down that automatically populates the PhoneNumber in the note, so I can just c+p it. Is that a thing? So I could select CompanyB and the note would auto come up as Reached out to customer to ask if customer wanted Blue Teapots, asked customer to call us back at PhoneNumber2.

    Thank you in advance!
    Last edited by loracarol; 08-18-2019 at 10:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using Drop downs in creating an estimating worksheet.
    By Duncan Wilkie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-19-2018, 11:21 AM
  2. Creating Dependent or Cascading Drop Downs
    By Draco119 in forum Excel General
    Replies: 3
    Last Post: 08-31-2018, 11:21 AM
  3. Need help in creating a form with drop downs
    By nileshsompura in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2018, 06:53 AM
  4. creating drop downs
    By ITFAQ in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-21-2015, 04:44 AM
  5. [SOLVED] Creating a Sales Order with Drop Downs
    By ExcelLover67 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-22-2014, 05:53 PM
  6. Creating dependent drop downs
    By harrybelly in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 05:08 PM
  7. Drop downs in Data Form
    By Gator9 in forum Excel General
    Replies: 4
    Last Post: 11-11-2005, 07:45 PM

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