Combining several workseets into a single worksheet

[Dragon 71]

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 formulae that can do this?

Thanks

[arlu1201]

A macro can do this automatically for you.

[Dragon 71]

Thanks

I have not used macros before so would not know how to write this
coulld you advise?

[arlu1201]

Try this code - I have named the summary sheet as "Summary".

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button