Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |