How do I make a summary page in Excel 2008?

M

mymeeshell

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have a sheet with all my data (several columns, one of which is "name" and others are things like "address," "notes," etc.). Then I have another sheet which is the summary. I want to be able to choose a name from a drop-down list (I figured out how to do that) for the "Name" and have the other fields ('address," "notes," etc.) fill in automatically with the information that corresponds to that name.

How do I do that? I got as far as creating the drop-down menu, but don't know how to set it up so that the "address" field on the summary page automatically fills in with "John Doe"'s address when I choose "John Doe" from the drop-down menu.

Thanks in advance for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top