Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo box on a column
I am (ok was) a database programmer, so maybe my brain is stuck in database
land. I am trying to make a spreadsheet. It is going to be an expense spreadsheet. Super simple. Date of the expense. Receipt number. But I want to assign a type to the expense from a list of 3 possibilities. I figured out how to make a combo box in a cell. But I really want the combo box to repeat on each new row I enter. Is this possible? I don't want to - Type the value of the type in because I cannot type. I will invariably make typos causing things not to group down the line. And I am very lazy. - Copy and paste the combo with each insertion. I want to be fast, fast, fast. Because fundamentally I hate doing the expense spreadsheet! Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo box on a column
Hi Stephanie,
Use Data Validation Select List and the Source field input your 3 possibilities ... That's it ... HTH Carim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo box on a column
If you copy the combo box down a thousand or so rows, that will keep
you going for a while. It's not consistent with database optimization guidelines, but that's one of the trade offs for using Excel as a database! (Kidding, not scolding.) If you do it this way you're done, and just have to remember to copy another thousand or so rows when you finish the first thousand. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo box on a column
"Carim" wrote in message ups.com... Hi Stephanie, Use Data Validation Select List and the Source field input your 3 possibilities ... That's it ... HTH Carim Waa Hoo. As I was not using the correct term to look up in help I did not find that. Thanks! Now that I think of it, I have done that before. Anyway thanks again. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo box on a column
Stephanie,
Glad I could help. Thanks for the feedback. Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Stock data manipulation | Excel Worksheet Functions | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |