View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
juliebythesea juliebythesea is offline
external usenet poster
 
Posts: 4
Default How to auto populate an invoice from data in an existing worksheet

Excel 2003...Is it possible to create an invoice that can be linked to a
worksheet whereby selecting a record in the worksheet then activating a
custom command (macro maybe) the invoice will be populated with the data from
the record? I'm thinking along the lines of a Word mail merge type function
but the invoice must have formulas in it.