import cells from another xls file

Joined
Feb 17, 2006
Messages
2
Reaction score
0
Hello! I have a file to which i want to import from another file certain cells. I want a function that will allow me to select the row where i import the data. I atached a file for you to see what i mean. In that file i need cells g11,h11,k11,l11,n11,o11,u11 to be replaced with the same number of cells from another file. I need that for any row not only for row 11. This would make my work a lot easier. Thank you very much!
 

Attachments

explaining..

Ok. In the file called indicatori, i want the cells g11, h11,k11,l11,n11,o11,u11 to be replaced with the same number of cells from another file. And the same thing for row 12, 13, 14..... The file from which i import will change all the time, but it will have the same layout, so the reference to the cells in that file will remain. So i would need a vba function to assign to a button. By pressing the button i would need an open window to open a predifined path, i would select the file from which i import the data and that is pretty much it! I cannot explain better what i need. Thanks for any help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top