Move Multiple Worksheets From Multiple Workbooks Into One Workbook

  • I need the code to write a macro that does the following:


    I have multiple workbooks in a folder labeled "final". I need to count the number of workbooks in that folder and then open each workbook up and move the fourth through sixth worksheet in each workbook to a consolidated workbook. The consolidated workbook will be in the folder above the "final" folder so it will not be counted.

  • Re: Move Multiple Worksheets From Multiple Workbooks Into One Workbook


    Quote from zraines

    I need the code to write a macro that does the following:


    I have multiple workbooks in a folder labeled "final". I need to count the number of workbooks in that folder and then open each workbook up and move the fourth through sixth worksheet in each workbook to a consolidated workbook. The consolidated workbook will be in the folder above the "final" folder so it will not be counted.


    open the workbook you wish to do this from
    start the macro recorder and perform the procedures you wish the macro to do then go the the module and check the results.
    post back if you get stuck
    HTH
    toe

Participate now!

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