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
    http://www.ozgrid.com/forum/showthread.php?t=60028

    Jim
    "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!