Also, you may be able to help me with another issue too (now I know I am pushing my luck.)

I have attached a workbook for you to see.

I have a sales order template that automatically generates and saves the workbook as a named sales order - what I really want it to do is to save the worksheet to a separate workbook where each sales order will have a separate tab - the sales agent then simply sends the workbook as one file via email to Head Office to process the sales orders in Sage.

My issue seems to be getting the sales order worksheet (prior to saving) into a separate workbook after the last processed sales order.

I think I am not too far off - but again I have just reached a stumbling block because my knowledge of VB is not what I would like.

Best wishes,

Ant