use macro to find a record from a long list

[asoom]

hello,

how can i crate a sheet that when you write a number of a rocerd "from a table in sheet 1" appers on a cell in sheet 2 ?

For example, i made a table in sheet 1 of deitals of a movie. this table has the numbers of movies and the location of it and when was it made.

i want to crate a sheet which is a place where they can look for movie details just by writing the Number of the movie. and the details appers for them

[xladept]

Hi Asoom,

You should consider using the Worksheet_Change event.

[asoom]

is there an easier way to do it ?

i'm kinda new in excel

i dont know how to use the Worksheet_Change event.

[asoom]

is there like a way other than writing formula

[xladept]

Hi Asoom,

Actually, the change event is one of the easiest to use - can you post a sample sheet? If you can I'll write some code for you and give you directions on how to use it

Post the spreadsheet, because I need a list of Id's & Names to play with