Product Price List and Invoice

**jamesahunt** · 02-19-2013, 05:28 AM

Hi all, I have been using excel 2003 to create basic spreadsheets and invoice/receipts templates which are totally manual apart for basic calculation e.g. addition percentages.

I am a self employed electrician.

I would like to create a spreadsheet (from now on i may have the wrong descriptive terminology) so i can produce a parts used which encompass costing as well. From this i can use it to produce quotations and invoices.

I use no more than say a selection of say no more than 500 differing product types with there up to date costings. I've been looking on the web and have come across, databases drop down list & Vlookup. But I'm really confused.

Any help steering me in the right direction would be appreciated.

**Pete_UK** · 02-19-2013, 06:17 AM

It would help if you posted the workbook you have now, so we can see how to improve it. Essentially, you need your list of products and costing on one sheet. Then on another sheet you could have a series of drop-downs where you can select the product codes and quantity that you have used for a particular job and formulae would then fill out the description and cost.

The FAQ describes how to attach a workbook to a post.

Hope this helps.

Pete