Theslaz, join our forums where you can attach a workbook where we would
be glad to resolve this issue for you.

It would be difficult to solve here as you need to let us know the
range the invoice number appears on, the range the date appears on, the
range the completed date should go and if you want the job status to
change after printing we also need to know the range that appears in not
to mention the sheets for all the above.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34925