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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com