Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have built a home budget workbook with 13 worksheets in it. 12 of the
sheets are named the months of the year eg. sheet 1 is Jan sheet 2 is Feb and so on. In each of the columns starting at column B is 1, column C is 2 and so on up to column AF which is the number 31 (which are the days). In the rows 3 to 212 I have typed in things like food, utilities ect. in all the cells in column A (which I'll call a category). I would like to have on another sheet, 4 drop down menus. One to choose the month (sheet 1 Jan to Dec), one to choose the day (the column B to AF) One to choose the category (the row 3 to 212) and the fourth one is where I put in a number that will be sent to the cell on the sheet that is at the intersecting row and column that I have selected in the other three drop down menus. Is this possible and can anyone help me? Garr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dropdown box display only data dependent on another dropdown box? | Excel Worksheet Functions | |||
Dropdown List within a dropdown | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
How do I create a dropdown within a dropdown? | Excel Discussion (Misc queries) |