Adding new data to sheet2 from sheet1

[ycwkpp898]

Hi i have 2 sheets in my workbook 1 called main and 1 called DVD, on the main
i have a simple enter the number of dvd and it displays the dvd info from
DVD, row B,c,d when it finds that number.
Here is my question i want to be able to if possible basically search for
the number if no infomation is there below i can add the new info eg



Dvd Name type Price
DVD Number 99 Lost Series 2 TV series £29.99


Dvd Name
Type
Price

if there is no info on a number i want to be able to enter this info below
and then get it to add the info.
I have no experience with Visual Basic, and been told i need to use Visual
Basic.

Ty for any info

 

[Joel]

first, you want to add the new DVD straight into the DVD sheet. There is no
need to added any place else.

On the main sheet it looks like you have lookup formulas that reference the
DVD sheet. All you need to do is to copy the formula to a new row on the
Main sheet and add the new DVD number to column A.

 

[ycwkpp898]

On the DVD sheet is the list of dvds in numerical order
on he main sheet i want it so that if it doesnt find any details just below
that on the same sheet be able to enter the dvd info and then it
automatically add the new data to DVD sheet in the correct number.
sorry my original post doesn't read correct.

 

[Joel]

1) Which cells have the new info?
2) Are you searching by title
3) what should the new DVED number be?
4) I don't think you want it to be automatic. Usally done by pressing a
button.

 

[ycwkpp898]

the below is Main sheet




Dvd Name type Price
DVD Number 99 Lost Series 2 TV series £29.99


Dvd Name cell B9
Type cell B10
Price cell B11


below is the DVD sheet

Number DVD Title Type Price
1 Lost Season 1 TV series 29.99
2 Lost Season 2 TV series 29.99
3 Lost Season 3 TV series 29.99
4 Lost Season 4 TV series 29.99
5
6
7
8
9 Simpsons Season 1 TV series 19.99

Basically if i put in 4 i would get
4 Lost Season 4 TV series 29.99
back on the MAIN sheet
but if i put 5 it would be blank info but i want to add the new info to DVD
sheet from Cell B9,B10 & B11 to DVD sheet num 5

ty for your help