Set SourceWB=ThisWorkbook
Set DestinationWB=Workbook.Open("Invoice.xls")

With SourceWB
DestinationWB.Range("InvoiceNo").Value=.Range("Inv oiceNo").Value
...etc

That what you mean ?

NickHK

With This
"bookkeeper" wrote in message
...
Can I export selected data from an excel worksheet into an excel invoice
template?