Good morning,
Have a review task to perform and I have created a worksheet template and a summary sheet. I have a macro that allows me to duplicate the worksheet as many times as I want. Once I have completed each worksheet, data is held in cells A93:F93. What I am looking for is a macro that transfers these values into the summary sheet cells D8:I8. So, the first worksheet values in A93:F93 will be transferred to cells D8:I8 in the summary sheet. The second worksheet values from A93:F93 need to go to the summary sheet D8:I8, but because the cells already have values, I need the macro to recognize that and offset to cells D9:I9....and so on and so on for the remaining worksheets. Thanks to all for reviewing this post.
Have a review task to perform and I have created a worksheet template and a summary sheet. I have a macro that allows me to duplicate the worksheet as many times as I want. Once I have completed each worksheet, data is held in cells A93:F93. What I am looking for is a macro that transfers these values into the summary sheet cells D8:I8. So, the first worksheet values in A93:F93 will be transferred to cells D8:I8 in the summary sheet. The second worksheet values from A93:F93 need to go to the summary sheet D8:I8, but because the cells already have values, I need the macro to recognize that and offset to cells D9:I9....and so on and so on for the remaining worksheets. Thanks to all for reviewing this post.