Copy data into many workbooks in one folder

[Pekkavee]

How can I copy data from one workbook into one cell ( say D10, Input " Length " ) in many other workbooks at the same time. The workbooks are similar in layout and are located in same folder. The workbooks only have one worksheet each with the same name.

I have about 500 workbooks which I want to update this way with same data.

Regards
Pekka

 

[Krishnakumar]

Hi Pekka,

You can have the code from here

HTH

 

[Pekkavee]

Thanks a million

This helps me a lot.

Regards
Pekka