| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixed 'Find' or 'Look up'? cell - is it possible?
I have a spreadsheet shared by several people for looking up project data.
I would like to create a fixed cell at the top to enter the project name or as much as they know. Probably labeled in an adjacent cell. It wouldn't need to replace data otherwise normal find is okay. Projects are added and removed so it may not be practical to select the excact names to put in a list. TIA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fixed 'Find' or 'Look up'? cell - is it possible?
What's your question?
Why not just "create a fixed cell at the top to enter the project name"? Regards, Fred. "Earl" wrote in message ... I have a spreadsheet shared by several people for looking up project data. I would like to create a fixed cell at the top to enter the project name or as much as they know. Probably labeled in an adjacent cell. It wouldn't need to replace data otherwise normal find is okay. Projects are added and removed so it may not be practical to select the excact names to put in a list. TIA |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fixed 'Find' or 'Look up'? cell - is it possible?
Depending on the layout of the data, you might be able to adapt Roger
Govier's Fast Filter sample file. Users could the * or ? wildcards with a text string to find a project in a list: http://www.contextures.com/excelfiles.html Under Filters, look for 'FL0020 - Fast Filter' Earl wrote: I have a spreadsheet shared by several people for looking up project data. I would like to create a fixed cell at the top to enter the project name or as much as they know. Probably labeled in an adjacent cell. It wouldn't need to replace data otherwise normal find is okay. Projects are added and removed so it may not be practical to select the excact names to put in a list. TIA -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fixed 'Find' or 'Look up'? cell - is it possible?
I'd like it to function just like find by highliting and taking you to the
row. But in a fixed way so they don't have to use find/replace. Just trying to make it as easy as possible for everyone. "Fred Smith" wrote: What's your question? Why not just "create a fixed cell at the top to enter the project name"? Regards, Fred. "Earl" wrote in message ... I have a spreadsheet shared by several people for looking up project data. I would like to create a fixed cell at the top to enter the project name or as much as they know. Probably labeled in an adjacent cell. It wouldn't need to replace data otherwise normal find is okay. Projects are added and removed so it may not be practical to select the excact names to put in a list. TIA |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fixed 'Find' or 'Look up'? cell - is it possible?
I couldn't fiqure anything out so far. I'll give it more thought. I's like to
stay in excel but someone suggested access. "Debra Dalgleish" wrote: Depending on the layout of the data, you might be able to adapt Roger Govier's Fast Filter sample file. Users could the * or ? wildcards with a text string to find a project in a list: http://www.contextures.com/excelfiles.html Under Filters, look for 'FL0020 - Fast Filter' Earl wrote: I have a spreadsheet shared by several people for looking up project data. I would like to create a fixed cell at the top to enter the project name or as much as they know. Probably labeled in an adjacent cell. It wouldn't need to replace data otherwise normal find is okay. Projects are added and removed so it may not be practical to select the excact names to put in a list. TIA -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What calculation can I use to find income on a fixed investment? | Excel Discussion (Misc queries) | |||
| how do I insert the address of a selected cell into a fixed cell | Excel Discussion (Misc queries) | |||
| can this be fixed to find for next name | Excel Discussion (Misc queries) | |||
| drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
| find-replace box should not float but be fixed line on tool bar | Excel Worksheet Functions | |||
Linear Mode
