I have 2 worksheets. One worksheet has a databse of: manufacturers - product
code - description - price.

The other worksheet is a cost sheet with multiple rows for the input of
product descriptions, model numbers and prices.

eg.
Item - Description - Qty - Product Code - Manufacturer - Price

Is there a way I could type model numbers in a cell and have the
description, manufacturer and price for that code automatically insert into a
cell on the same row?

Please note I know very little about macros or MS Access.

I would appreciate any help forthcoming.

Regards,

Jonny