ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   DropDown (https://www.excelbanter.com/excel-discussion-misc-queries/220931-dropdown.html)

garr

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