Copy By Criteria To New Workbook

  • I have a spreadsheet (job register) which is used to record all our jobs and the job numbers. I want to automate it so that various data is recorded on the job register and also transferred to a separate job sheet. Here is where it gets tricky; I want to copy the job number onto a new workbook (that is created from a template) and save this workbook as the job number.

    The code I have so far is ...

  • Re: Copy By Criteria To New Workbook

    To copy sheets and save, see

    "The problem with designing vba code completely foolproof is to underestimate the ingenuity of a complete fool."

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!