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

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    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