Copy specific worksheets to another workbook based on critirias / vba

  • Hallo,


    I have a quistion and I hope that I can find here an answer

    i have 10 folders (10 section in the company) and every folder contains 12 workbooks (12 months). and i have a master workbook which has a searching cells: first cell: name of the section second cell: from month third cell: to month.
    I want a macro that help me when i fill the 3 cells to copy the required sheets in the master workbook ( for example: section: 1 , from month: 1, to month: 5) the result will be: 5 sheets from first month to fifth i hope that you understad me.

    thanks alot :)

Participate now!

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