Dropdown list based workbook.

Good day everyone,

Obviously I'm new to the forum, and I'm not sure how to narrow what I'm looking for into a few words, otherwise I would search it out. So here it is:

I work for a trucking company, and we deliver to a number of locations. I'm trying to make a sheet that's easy for others to use so they can acquire location information.

The format I'm trying to get is a drop down list that shows all the location codes. This I can do. What I can't figure out is how to format the cells below the drop down list to change as different selections are made from the drop down list.

So I'd like to have the data for each location stored on another sheet in the workbook that the main sheet can pull from and list below.

The top of the main sheet will say Store Location: (drop down list with all the location codes)

Then below, I'll have different parameters for the various data pertaining to the selected location, i.e. phone number, address, driving directions.

The main goal is for my dispatchers to open the workbook, select a location code from the drop down list, then all the data for that specific selection appear below, then they will be able to print the sheet with only the information of the selection from the drop down list.

Any guidance is appreciated.

There is a short example what can de done.

Is this kind of functions that you are planning to have?

This is a simple but functional worksheet.

http://www.4shared.com/document/evaS0Ji4/example_1.html


.

Weclcome to the forum, APWalker.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

APWalker, It was a pleasure to help you.

Have a nice week.


.

Your post still does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.