#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dropdown box display only data dependent on another dropdown box? Chris Excel Worksheet Functions 8 August 5th 08 05:01 PM
Dropdown List within a dropdown Henn9660 Excel Worksheet Functions 1 April 10th 08 07:42 PM
result of selecting from the dropdown list should be a dropdown list No News Excel Worksheet Functions 2 July 1st 06 10:53 AM
offer dropdown options based on another dropdown Conor Excel Discussion (Misc queries) 2 January 13th 06 04:28 PM
How do I create a dropdown within a dropdown? Joyce Keller Excel Discussion (Misc queries) 1 December 5th 05 04:02 PM


All times are GMT +1. The time now is 01:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"