You can't do that with a formula - VBA programming would be required. Besides which, the details you've given us so far don't amount to much - a customer name and service type. Presumably, there'd be a bunch of other data that needs to go into the Sales or Repair workbook, but you've given us no indication of where that comes from or where it is to go.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]