Macro for data consoladation

[Vikky]

Hi Experts;

I require a macro, which can help me to consolidate data from
different Excel file lying in one folder. All these excel file would
be having two different sheets with similar name in all files.

Kindly Help.

Regards;

Vikky

 

[Ron de Bruin]

Hi Vikky

You can try this add-in
http://www.rondebruin.nl/merge.htm

Or use one of the code examples on the bottom of the page