copy to different workbooks

[sahu.sitaram]

Hi,

I have more than 10 workbooks in same format and in same folder. I want to past a particular figure in a certain cell like $25 in cell k5 on every workbook of sheet1. It takes lot of time to open each workbook and paste the same information. Is there anythings that could help me to save my time. I don't want to use VBA codes. Just in simple way to do it.

Thanks
Sahu

 

[GTO]

Other than using explorer and selecting all the files to open them all at once, I don't see anyway you will speed up manual entry in multiple books.

 

[sahu.sitaram]

Thanks dear,

Is there anything that without opening the excel file i can paste the require data in a particular cell. I am not good in vba. Hence if there is any easy way or any formula then please advice me. It will really help me lot. Thanks in advance for ur help.

Thanks
Sahu.