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