Hello
since I do not know much about VBA excel I hope you can help me. I searching this forum 2 days, and cant solve my problem.
My problem is a bit complex for me, but it is easy for someone who knows VBA.
Example:
I have Workbooks "house1" and when I enter data in cell "A1" to "A7", I get the sum in cell "A10" in "sheet1", now I have to copy cell "A10" and more 4 cells, lets say "B12" "B15" "C23" "D9" into Workbooks "house2" in "N1" "N4" "N7" "M4" cell in "sheet1". I need to find that workbook "house2", because there is so many folders under folders (100 or more) and after paste data in "house2", need to left open the file "house2".
If anyone have time to answer, I will be grateful!