Copy/Paste from three sheets into one?

[mesh1o]

Hello i have three files:

Appendix 1.xls
Appendix 2.xls
Appendix 3.xls

And in each file i want the cell range from a9-g18 to be copied (so appendix 1,2 and 3 i want them cells copied)

anbd pasted in copy1.xls as one sheet all under each other with one line gap?

any ideas?

thanks

[boylejob]

Mesh1o,

See if this will get you started. You are going to have to make some modification because I don't know here you files are located. I have this set up so it will loop through 3 appendix files. If you have more, you can simple change the loop to however many it is that you have. You may also need to look at the worksheet names unless your files are using the Sheet1, Sheet2, etc. defaults.

I am giving you a sub and a function. The function simply sees if the file is open and if it is not it opens it.

Please Login or Register  to view this content.

I hope this helps you get started.