I am trying to create a drop down list for inventory locations, like tool
crib, shed, yard, etc. How do I go about creating one.
--
Adam Gould

Hi
Look into Debra web has excellent explanation and examples

http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlDataVal13.html#Create
http://www.contextures.com/xlDataVal02.html

"Adam gould" wrote:

I am trying to create a drop down list for inventory locations, like tool
crib, shed, yard, etc. How do I go about creating one.
--
Adam Gould

Hello!

You can make a drop down list by:

1) Highlight the cell where you want the list to show up

2) Click data, then validation

3) Allow list

4) Then designated the row/column where the information of the drop down list will come from

Voila. You have your own drop down list.


For more tips on excel and financial models, you can check this out. Hope this helps!