Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create a pick list to use to go to a text cell in Excel
One spreadsheet tab contains multiple project reports of about 20 lines each.
Each section has a text header. I want to create a pick list in a cell at the top of the tab so I can quickly go to a project header and see the report for that project. Just using a filter won't work, I need to see the 20 lines following the header. I need either a find or a go to that will pick the project name from the list, but it needs to be a permanent function set up in a cell. Can I do this within the functions of Excel, or do I need a macro? I'm not macro-wise. |
#2
|
|||
|
|||
You can name the ranges, as explained he
http://www.contextures.com/xlNames01.html Then, select a name from the Name box, to go to that range. Pegita wrote: One spreadsheet tab contains multiple project reports of about 20 lines each. Each section has a text header. I want to create a pick list in a cell at the top of the tab so I can quickly go to a project header and see the report for that project. Just using a filter won't work, I need to see the 20 lines following the header. I need either a find or a go to that will pick the project name from the list, but it needs to be a permanent function set up in a cell. Can I do this within the functions of Excel, or do I need a macro? I'm not macro-wise. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
Combining text and cell value to create a sentence | Excel Discussion (Misc queries) | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Moving text from one cell to another. | Excel Worksheet Functions | |||
Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) |