HI
I have been asked to set up a function that automatically combines three separate worksheets into a another single worksheet , ordinarily I would copy and paste the required fields into the other workseet but my recipeints require this to be an automatic function.
Each of the three wokshhets only need fields A to L to be copied into the other workheet in the same workbook. The workseet will need the information to overwrite every time it is used. Also the info to be copied cotains formulae but I only need th values in the cells to be copied over.
Is there a formula that can do this?
I think there is a macro for this, but not having used macros before I could use soem siistance in how to set ths up please
.Thanks
I have been asked to set up a function that automatically combines three separate worksheets into a another single worksheet , ordinarily I would copy and paste the required fields into the other workseet but my recipeints require this to be an automatic function.
Each of the three wokshhets only need fields A to L to be copied into the other workheet in the same workbook. The workseet will need the information to overwrite every time it is used. Also the info to be copied cotains formulae but I only need th values in the cells to be copied over.
Is there a formula that can do this?
I think there is a macro for this, but not having used macros before I could use soem siistance in how to set ths up please
.Thanks