This example describes my problem (I hope):
Have two Excel files. c:\temp\test1.xlsx and c:\temp\test2.xlsx. When clicking a button in the open file "test2" I want to copy values from cells B10:D10 in the closed file "test1" to cells B2:D2 in "test2".
I know how to wite and use simple vba code, but this is a bit above my head. Appreciate any help.