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" wrote:

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" wrote:

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