Multiple Sheets in to one sheet

[BharathBabu]

I have 6 Sheets of data in one workbook... and

I want to get all the 6 sheets of data in one sheet in other workbook file..

Please advise the formula or vbscript or macros

 

[Debraj]

Hi Bharat,


In the right top side, there was a SEARCH box, try to search with keyword..

You may find a huge list of example..


http://chandoo.org/wp/search/?q=consolidate%20data%20from%20multiple%20to%20excel


Regards,

Deb