Macro to consolidate all the data into single file

[Santhi28595]

Hi team,

I am having an Excel sheet having each data in a separate tab. I want to consolidate the data in different tabs, to generate a consolidated file.

Can anyone please help me to create a macro which consolidate excel files.

[Haluk]

Try this;

Please Login or Register  to view this content.

.

[Santhi28595]

Hi Thank u. I will try. Do I need to create a button or how do I execute the code.

[Santhi28595]

Hi can you please let me know how to execute the code.

[Santhi28595]

Team can anyone please help me out !!!

[jindon]

How do you want the result?

[Santhi28595]

Hi I need the data which is the separate tab in the Excel sheet should be converted into a single Excel file.

[jindon]

Just copy full range form each worksheet including each header?

"Consolidate" is just too rough to explain.

[Santhi28595]

I apologise. Header should be copied once and the remaining data in the tab should be copied into a single Excel file.

[jindon]

Please Login or Register  to view this content.

[Santhi28595]

Hi thanks. I apologise I am new to vb. Can u tell me how to execute this code. And also if I add any new columns in the sheet, should that need to be declared in the code.

[jindon]

1) Hit Alt + F11 to open VBE(Visual Basic Editor)
2) [Insert] - [Module]
3) Paste the code on to the right blank space and hit Alt + Q to get back to Excel
4) Hit Alt + F8 and select "test" then Run

[Santhi28595]

Hi thanks I did try it. But after running I am not seeing the consolidated file.can u check where I am going wrong.

[jindon]

The new FILE(workbook) should be saved in the same folder.

[Santhi28595]

Just tried it works perfect buddy. Thanks a lot. I have one last doubt. If I have the same data in separate excel will the same code works to consolidate into a single file.

Currently the test file I have here is the data in a separate tab but now my question is if the same data is in a separate excel file does the same code works to consolidate

[jindon]

Simply NO.

It's a completely different question.

[Santhi28595]

Oh ok. So do we need to write a code for that as well. I would need that also. If you could help me that would be great.

[jindon]

You need to open a new thread for your new question.

If your original question is solved, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[Santhi28595]

Yea thanks jindon. I will open a new thread.

I really appreciate all your efforts to solve my query.