Here’s what I want to know: Is it possible, using Excel and the relationships option, to link these particular names/records to a particular movie in Worksheet #1, so that if I filter Worksheet #1, the corresponding data in Worksheet #2 is filtered automatically, as well? I want to be able to list several actors for one particular movie.įor example, the movie Jaws has three main actors: Roy Scheider, Robert Shaw, and Richard Dreyfuss. I’d like this worksheet to be for actors. Worksheet #2 is the one I’m most concerned about. It will have the title, its location in my house (my movies are color coded and numbered to signify where they are in my home), and a few other details, such as whether it is a foreign film, or a silent film. Worksheet #1 will have the basic details of the movie. In other words, I hope you’ll indulge me.Īnyway…I want to design a spreadsheet with three worksheets. I’m just curious to know if what I want to do is possible, aside from databases. Databases are much more complicated to me (especially many-to-many databases) than spreadsheets. I’ve designed an Access relational database for this, but I want several calculations and percentages for various things. Before I continue, I know a database is probably better for this than a spreadsheet. I’d like to design a spreadsheet that serves as my movie collection catalog. Let me tell you, please, what I want to do. I upgraded from Excel 2010 because it now contains a "relationships" feature, which I may need help with. I don’t do anything fancy or elaborate, but I would like to ask a question or two about designing a particular kind of spreadsheet. I consider myself a novice at spreadsheet design. I recently invested in Office 365, and am using Excel 2016 (which is new to me).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |