i need a basic invoice template with following requirements:-
i have many styles. like style 1, style 2, style 3 etc. Each style has a fixed selling price. For example Style 1, selling price is $1, style 2, selling price is $3.5 etc.
So i need to be able to input all style numbers and their selling prices in one sheet.
Then in sheet 2, i need an invoice template, which can be saved by date, so for example if i create an invoice for 1st march, then i can save that invoice as 1st march in excel
In this invoice template if i enter the style numbers which exist in sheet 1, then their selling price should be shown automatically, so that i dont have to reenter it
I need following columns in Sheet 2(where i will create invoice)
style number (i will enter it manually, once entered check if exist in sheet 1)
style price (should come automatically if style number exist in sheet 1)
style quantity (i will enter it manually)
start weight (i will enter it manually)
end weight (i will enter it manually)
weight different (different between start and end weight)
total price (style quantity x style price)
then total invoice amount. then i should be able to save the invoice for future record.
Also note that i will contanstly be updating the style numbers, their cost, or adding new styles and their cost in sheet 1.
let me know if this is possible and if you can do this urgently