Copy all data into one sheet

[rizmomin]

I have excel worksheet with lots of sheet with data in Column A and Column B
I need a macro to copy all column A and Column B data from all sheets in let's say sheet called "Consolidate".

Please help me achieve this...

Let me know if you have questions..

Thank You...

Riz Momin

[Paul]

Hi Riz,

Are you saying that you have one workbook that has many sheets, and those sheets all have data in columns A and B?

And you want to copy those columns from each sheet into one main sheet called "Consolidate" and have all that data in columns A and B as they were on the original sheets?

[rizmomin]

yes, exactly right....

Thnx

[Paul]

Ok then try this macro:

Please Login or Register  to view this content.

To add this macro to your workbook:
Press ALT+F11 to open the VB Editor
Click Insert -> Module
Copy and paste the code shown above into the empty code window
Close the VB Editor and save your workbook
To run the macro, press ALT+F8, select Consolidate and click Run.

Hope that helps!

[rizmomin]

This works great,,

Thank u so much for your professional help.


Riz Momin

[beckham3mr]

hello,
can you please tell me if i need to collect data from many workbooks and put them in one sheet in new workbook

[rizmomin]

Hi Beckham3mr:

For above macro to work, you need one excel workbook with many sheets and all sheets have data in Column A and Column B.
The above macro will copy data from Column A and B from all sheets and put in "Consolidate" sheet.

Riz Momin

[beckham3mr]

Hello rizmomin ,

yes, i try it and it is working but this is not what i need .because i need to collect the data from many excel workbook and put in one workbook .
thanks for you support

[arlu1201]

beckham,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.