G
Guest
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.
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.