G
garr
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
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