Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 37
Default big list. Need advice for a new user of how to streamline it

Hey guys would really love some help.
I am putting a list of the best movies of all time together in my spare
time. I have movie name - year of release - director all in one coulmn.
Firstle I would like to know if there is a function that I could get similar
to a find/search so if I need to check the list for a title I could
iinstantly see if was there rather that trapse through 1000 entries.
Also I'm sure there are plenty of people out there that have done something
similar and I would appreciate any ideas on how to develope the sheet.

Any comments would be appreciated

Kent.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 95
Default big list. Need advice for a new user of how to streamline it

Hi Kent
Have a look at this site for a sample template.
HTH
Cimjet
http://office.microsoft.com/en-us/templates
"Kent" wrote in message
...
Hey guys would really love some help.
I am putting a list of the best movies of all time together in my spare
time. I have movie name - year of release - director all in one coulmn.
Firstle I would like to know if there is a function that I could get
similar
to a find/search so if I need to check the list for a title I could
iinstantly see if was there rather that trapse through 1000 entries.
Also I'm sure there are plenty of people out there that have done
something
similar and I would appreciate any ideas on how to develope the sheet.

Any comments would be appreciated

Kent.


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default big list. Need advice for a new user of how to streamline it

Hi Kent,
If you want to stay with your current workbook, it would be more
manageable if the Name, Year of Release, Director etc each had their
own column. Later, you can add more columns as you think of them - eg
Genre, Studio, etc. You can then easily sort by Name, Director, or by
any column heading. Search macros would also be simpler to write.
You can probably use DATA TEXT TO COLUMNS to separate your data,
depending on how your info has been inputted.
Regards - Dave.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data validation list: how do i 'force' a user to enter data from the list? showsomeidnow Excel Discussion (Misc queries) 4 May 1st 07 05:49 PM
data validation list: how do i 'force' a user to enter data from the list? showsomeidnow Excel Discussion (Misc queries) 2 April 29th 07 11:09 PM
Need some help to streamline my very large 2003 excel workbook ktatey Excel Discussion (Misc queries) 0 November 9th 06 02:44 PM
How to streamline this Formula? Kuda Excel Discussion (Misc queries) 1 February 7th 06 03:05 PM
streamline SUMPRODUCT gpie Excel Worksheet Functions 4 September 23rd 05 06:05 PM


All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"