how to use a dropdown list to show data in 1 table with excel?

Ive created a table to show types of insurance with policy numbers and expiration dates. Is there a way to make a dropdown list of our clients that i can click on to fill the table i made? opposed to creating a table for every client..

1 Answer

Relevance
  • 6 months ago

    YOu may want to do this with Access, a database, rather than Excel, which is just a spreadsheet.

Still have questions? Get your answers by asking now.