Automatically creating 8x12 grids on one workbook from 96 row list on another workbook

    Thank you, this worked perfectly!


    And do I have to change the source workbook/destination workbook name in the macro after each experiment I run or is there a way this can be automated?


    Thanks again for the help and patience.

    rory


    Thanks a lot for having fixed the Cells Copy instruction :thumbup:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Carim

    No worries. :)

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

    Quote from maehar

    ...

    And do I have to change the source workbook/destination workbook name in the macro after each experiment I run or is there a way this can be automated ?

    ...

    Your latest question is quite vague ...


    Could you be more explicit ?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

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

Register Yourself Login