combo box

[Steve]

Hello Again

heres what I'm trying to do.
I have a combo bo that I figured out how to put a list of
stores in. now I would like to have the name from the list
put into the cell that I am in. I'll be putting a diferent
store name into different cells.
what I'm doing is going through our old checks for the
year and I want to total the amount from each store and
bill we pay. and I thought it would be easier to have a
drop down box with a list of our expances to select from
rather than type each one then put the total spent behind
it.
hope this makes sense
steve

 

[Max]

Think what you need is Data Validation
applied down the col(s) where you're putting the stores.

Here's the oft quoted link to MVP Debra D's nice coverage:
http://www.contextures.com/xlDataVal01.html

 

[steve]

ok thank you I'll check it out tomorrow night.
I appretiate the help
Steve

 

[Max]

Steve, you're welcome!
Thanks for the feedback.

btw, Debra D's page is accessible 24 x 7 <g>

cheers
Max