Search results
Dec 8, 2010 · To use it enter your movies on the Movie List Tab. There are alot of options, all which are requirments for me, so you might have to play around with it. You can see the code for this spreadsheet by right clicking on Select Movies and view code. I took this example.
Check out our dvd list template selection for the very best in unique or custom, handmade pieces from our templates shops.
Jan 14, 2006 · Thomas Nguyen dreams big. Nguyen, who is also known as Quoc Thai, immigrated to America in 1975 and quickly became a leader in the Vietnamese entertainment business. He plays in a family band, foun…
- The Data Entry Sheet
- The Movie Selector Sheet
- The Criteria Sheet
- The Lists Sheet
- Use The Database
- Download The Sample File
On the data entry sheet, named Movies List, there’s a table with seven columns. A unique ID number is entered for each movie, then the title, and other information about the movie. The database was named MovieList, using a dynamic range. In Excel 2007 you could use an Excel Table instead, and in Excel 2003 you could use an Excel List.
On the report sheet, named Select Movies, there are two drop down lists – one for Category and one for Actor. Select from either of those, and code automatically runs, to filter a list of movies that match your selection. The yellow cells are named (SelCat and SelActor), and the block of green cells is a range named ExtractMovies. To see the code, ...
The code runs an Advanced Filter, just as you could do manually. There’s a criteria area for each type of filter, stored on the CriteriaSel sheet. If you select a Category from the drop down list, the Category criteria range is used for the Advanced Filter. If you select an actor, the Actor criteria range is used.
The final sheet in the workbook stores the lists that are used in the yellow drop down cells. These are pivot tables, based on the MovieList database. The pivot tables are automatically refreshed when the workbook opens, and when you deactivate the data entry sheet.
To use the database, enter movie information on the Movies List sheet. Then, select a category or actor, and a report is created on Select Movies sheet, with all the movies that meet the selected criteria. The criteria sheet and Lists sheet are automatically updated, so no changes need to be made to those sheets.
To see the code and test the sample file, you can download the Excel movies database file. It’s in Excel 2003 format (xls), and the file is zipped. The file contains macros, so you’ll have to enable those to make the file work. ______________
Truong Minh Quoc Thai Reels. 58,896 likes · 28,155 talking about this. http://www.facebook.com/home.php?#!/truongminhquocthai. Watch the latest reel from Truong Minh ...
Download our free CD & DVD Templates for use with your disc manufacturing project. When you download templates below, you will get a .ZIP file that contains templates in multiple programs. You will need to save this to your computer, and then "un-ZIP" to get access to the templates. (If you are on a Mac, double click the file to de-compress it ...
Quoc Thai Entertainment. 96 likes. Entertainment website
