Need Help in Macros to Copy a row from different WorkBooks to one sheet one after one

[Vcare]

Hi,

I need a macro help.

Need Help in Macros to Copy a particular 2nd row from different workbooks. All these workbooks will be in a particular folder. In all workbooks sheet "DATA" is common, from this i need to copy the 2nd row & paste special the value one after one in a active Master Work Book.

There will be a data collected from each employees in a different work books, In all these files "DATA" sheet is common. From these DATA sheet i would like copy & paste special particularly 2nd Row to my master workbook.

Can you please help me in this.

Thanks & Regards,
VK

[kasan]

Try this one, just change red values to your folder path to files and name of sheet in master wokrbook.

Please Login or Register  to view this content.

[Vcare]

Thank you kasan. It works perfectly.