View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
billstef billstef is offline
external usenet poster
 
Posts: 1
Default In Excel, print a business invoice from order data in a worksheet

I have orders for my products along with customer info in a worksheet. I
want to print a business style invoice summarizing the order and calculating
costs for each customer. How do I get Excel to print out a line on the
invoice for just the products ordered and not all the products
available(which is what is represented in the worksheet). are there any
templates available or add-ins that draw data for invoces from other
worksheets?