Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pegita
 
Posts: n/a
Default 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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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
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
large text amount in cell will not display in the cell dbelch01 Excel Discussion (Misc queries) 3 June 15th 05 03:43 PM
Combining text and cell value to create a sentence StephanieH Excel Discussion (Misc queries) 4 June 13th 05 11:53 PM
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 08:10 PM
Moving text from one cell to another. estaban botas Excel Worksheet Functions 1 December 15th 04 03:04 PM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 08:10 PM


All times are GMT +1. The time now is 07:39 PM.

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

About Us

"It's about Microsoft Excel"