| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Program Question
Awesome! Thank you all very much!
"MyVeryOwnSelf" wrote: I have a worksheet that I am working on that has 13 pages. 12 pages that represent the months in the year and the 13th page is the planner page. On the planner page there is an area where the user may select a month and on that portion of the planner worksheet I would like for it to be able to populate the planner work sheet with the percentages from the same month the user is requesting. ... A43 is where the user can select the month from a drop down list. A45 is where the results should show from pulling from the sheet labeled matching the month the user has selected. C3 is the cell on the sheet of the selected month of the user. Here's one way. In the A43 drop-down list use the same names that are the tab names; maybe, Jan, ..., Dec. Then in A45 put =INDIRECT(A43&"!C3") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Program | Excel Worksheet Functions | |||
| can vb from excel launch another program? | Excel Worksheet Functions | |||
| Excel program | Excel Discussion (Misc queries) | |||
| Excel program | Excel Discussion (Misc queries) | |||
| How do I set up a min max program in excel? | Excel Worksheet Functions | |||
Threaded Mode
