Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2004

Tip: Looking for answers? Try searching our database.

using excel as a database for movies and cd collection help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
§kipTr@cer - 27 Oct 2004 11:45 GMT
hi, ive been using excel to maintain a list for my cd's and moves etc just
wanted to make it more functional but as im a noob im not sure what i can do,
as it stands i have a workbook with a sheet for each catagory cd's movies tv
shows etc, with a cell comment giving details of the item like the list of
episode titles in a tv series. im using ctrl + f to search and using a red
cell for stuff ive lent to friends, i would really like to enhance this
workbook maybe add a stats page, see if there is some way to list the number
of red cells etc, improve the searching, count the no. of films and generally
use this as an opertunity to learn more about excel
Signature

"i am not a number, i am a free man...."

Bernie Deitrick - 27 Oct 2004 19:17 GMT
The best thing would be to not use multiple sheets, but use a single
database with another column that has the category.  That way, you can
filter the list (to see just certain categories or sub-categories, along the
lines of Movies, 2003 - your data set will determine the possiblilities) or
to use it as the basis of a pivot table, where you can see summaries.

HTH,
Bernie
MS Excel MVP

> hi, ive been using excel to maintain a list for my cd's and moves etc just
> wanted to make it more functional but as im a noob im not sure what i can do,
[quoted text clipped - 5 lines]
> of red cells etc, improve the searching, count the no. of films and generally
> use this as an opertunity to learn more about excel
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.