I have our price list and stock levels in Excel. I want to create a Word template invoice that I can type a product in and the template will get the price from Excel and alter the stock levels on the Excel sheet. I realise I might be asking something simple but you could be saving me hours of trial and error.
