copy multiple sheets data into one sheet

[R GROVER]

How to copy data from multiple sheets of one worksheet to a single sheet of another worksheet

[arlu1201]

Do you mean you want to copy the data from multiple sheets of one workbook to a single sheet of another workbook?

Will the destination and source files be open at the time of running the macro or should the macro open either of them?

Where will the macro reside? In the destination file?

Is the format of all the sheets the same - i mean do they have the same headers?

Which is the last column containing data in the source file?

[R GROVER]

Re: copy multile sheets data into one sheet
Do you mean you want to copy the data from multiple sheets of one workbook to a single sheet of another workbook? YES

Will the destination and source files be open at the time of running the macro or should the macro open either of them? YES CAN BE OPEN

Where will the macro reside? In the destination file? YES THE MACRO CAN RESIDE IN DESTINATION FILE

Is the format of all the sheets the same - i mean do they have the same headers? YES

Which is the last column containing data in the source file? LAST COLUMN IS "G", THE LAST ROW IS VARIABLE.

[arlu1201]

Try this code

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 Tools | Macro | Macros
Select a macro in the list, and click the Run button

[tianshu]

Dear Arlette,
Thanks. I recently came across the same problem and your macro is a great help for me. I have used it, it is excellent. By the way, can the macro be improved to handle the situation where I have multiple workbooks and multiple sheets in each workbook and I want to combine all together into one worksheet in one workbook?

Thanks
T.

[arlu1201]

Tianshu,

In order not to confuse your question with the original one posted, why dont you open up a new thread and PM me the link. I can help you with it.

[tianshu]

Thanks. Arlette. I have opened a new thread as you suggested. I enclose the link here (http://www.excelforum.com/excel-prog...-workbook.html).
T.