Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question Concerning Look of SpreadSheet
Hello Microsoft community,
I had a quick question concerning the look of my spreadsheet. It is a fairly simple spreadsheet so I think someone with more knowledge of Excel might be able to answer easily. The spreadsheet I am referring to is a catalog of documents. These documents are organized by categories that get more specific. For example column 1 is general, 2 is a bit more specific, and 3 is very specific. There is then a brief description following columns that describe the type of document it is (article, book, etc.) as well as language and title of the document. Now for my question. I was wondering if there is anyway to make this spreadsheet more search able and like a type of database. If possible, I would like users to be able to click the categories and then have them get more specific until they were finally at the article of choice. Is this possible in anyway? Am I right in thinking that Excel is capable of something like this? Is there any place I can find an example, tutorial, or just more information in general on this type of thing? The only other example I can think of that compares to something like this is that of a library. Thank you for your time |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question Concerning Look of SpreadSheet
See
http://contextures.com/xlDataVal02.html for one way. In article , Longtime listener first time caller soft.com wrote: Hello Microsoft community, I had a quick question concerning the look of my spreadsheet. It is a fairly simple spreadsheet so I think someone with more knowledge of Excel might be able to answer easily. The spreadsheet I am referring to is a catalog of documents. These documents are organized by categories that get more specific. For example column 1 is general, 2 is a bit more specific, and 3 is very specific. There is then a brief description following columns that describe the type of document it is (article, book, etc.) as well as language and title of the document. Now for my question. I was wondering if there is anyway to make this spreadsheet more search able and like a type of database. If possible, I would like users to be able to click the categories and then have them get more specific until they were finally at the article of choice. Is this possible in anyway? Am I right in thinking that Excel is capable of something like this? Is there any place I can find an example, tutorial, or just more information in general on this type of thing? The only other example I can think of that compares to something like this is that of a library. Thank you for your time |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question Concerning Look of SpreadSheet
Thank You JE McGimpsey. I am looking through some of the sample spreadsheets
for some ideas and see a couple possibilities, are there any of those examples that you had in mind? Once again thanks for your input, anyone else have some other ideas? "JE McGimpsey" wrote: See http://contextures.com/xlDataVal02.html for one way. In article , Longtime listener first time caller soft.com wrote: Hello Microsoft community, I had a quick question concerning the look of my spreadsheet. It is a fairly simple spreadsheet so I think someone with more knowledge of Excel might be able to answer easily. The spreadsheet I am referring to is a catalog of documents. These documents are organized by categories that get more specific. For example column 1 is general, 2 is a bit more specific, and 3 is very specific. There is then a brief description following columns that describe the type of document it is (article, book, etc.) as well as language and title of the document. Now for my question. I was wondering if there is anyway to make this spreadsheet more search able and like a type of database. If possible, I would like users to be able to click the categories and then have them get more specific until they were finally at the article of choice. Is this possible in anyway? Am I right in thinking that Excel is capable of something like this? Is there any place I can find an example, tutorial, or just more information in general on this type of thing? The only other example I can think of that compares to something like this is that of a library. Thank you for your time |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question Concerning Look of SpreadSheet
The site JE posted shows you how to make dependent lists.
Select from category list to get a list of items for that category. Select from item list to drill down to a list of specifics for that item. If you want a sample workbook try one of these from http://contextures.com/excelfiles.html#DataVal DV0044 - Dependent Cell List Multiple Offset DV0037 - Dependent Lists Country City DV0030 - Dependent Cell List Lookup Gord Dibben MS Excel MVP On Wed, 28 Feb 2007 01:52:16 -0800, Longtime listener first time caller soft.com wrote: Thank You JE McGimpsey. I am looking through some of the sample spreadsheets for some ideas and see a couple possibilities, are there any of those examples that you had in mind? Once again thanks for your input, anyone else have some other ideas? "JE McGimpsey" wrote: See http://contextures.com/xlDataVal02.html for one way. In article , Longtime listener first time caller soft.com wrote: Hello Microsoft community, I had a quick question concerning the look of my spreadsheet. It is a fairly simple spreadsheet so I think someone with more knowledge of Excel might be able to answer easily. The spreadsheet I am referring to is a catalog of documents. These documents are organized by categories that get more specific. For example column 1 is general, 2 is a bit more specific, and 3 is very specific. There is then a brief description following columns that describe the type of document it is (article, book, etc.) as well as language and title of the document. Now for my question. I was wondering if there is anyway to make this spreadsheet more search able and like a type of database. If possible, I would like users to be able to click the categories and then have them get more specific until they were finally at the article of choice. Is this possible in anyway? Am I right in thinking that Excel is capable of something like this? Is there any place I can find an example, tutorial, or just more information in general on this type of thing? The only other example I can think of that compares to something like this is that of a library. Thank you for your time |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spreadsheet question | Excel Worksheet Functions | |||
Spreadsheet formula question! | Excel Worksheet Functions | |||
Spreadsheet Question | Excel Discussion (Misc queries) | |||
EXCEL SPREADSHEET SET-UP QUESTION | Excel Worksheet Functions | |||
spreadsheet design question | New Users to Excel |