If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 PM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
How do I create a bulleted list text format inside cell? | DEH | General Discussion | 5 | February 1st, 2005 07:37 AM |