Hi Chinmaybl

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




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chinmaybl" wrote in message ps.com...
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