![]() |
DropDown
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 |
All times are GMT +1. The time now is 12:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com