I need help with excel. I have a product list in excel where products are
are Identified with a four digit code. E.G.

Code Product Desc Net VAT
Total

2354 Bleach General Cleaner £10 £1.75
£11.75

Lets call this the master list, it has 400 entries. I want to be able to
produce customer quotes on subsequent worksheets within the workbook. I
would like lines to 'autocomplete' after entering the product code alone. I
do not know how to link new sheets to the master sheet with the product list.
I am not an advanced user so any help in 'baby steps' please? Thanks.