Macro to Pull data from multiple excel sheets

[Chinmaybl]

Hi Guys ,
I have 50+ locations .The engineers from respective locations send
excel sheets every week .
what I do is pull data manually from each sheet and make a
consolidated report.

Is there any way where in a MACRO pulls data from all these sheets one
by one ,depending upon what cell/row range we specify for the target
excel sheet and appends in the active worksheet.

Any help would be great.

Thanks
Chinmay

 

[Ron de Bruin]

Hi Chinmaybl

Start here
http://www.rondebruin.nl/mail/folder2/saveatt.htm

 

[Chinmaybl]

Hi Chinmaybl

Start herehttp://www.rondebruin.nl/mail/folder2/saveatt.htm

Hi Ron,
That was simply Great....!!!!!!!......Thanks a lot

regards
Chinmay

 

[NKL]

Message has moved

Hello,

The question that was asked was exactly my question, but the website posted http://www.rondebruin.nl/mail/folder2/saveatt.htm is now for Outlook. Do you have the address for where this information is currently located???

Thanks,
Kendra