Copy range from user selected sheet of another file to original worksheet

Hi,

What I'm trying to do is open a new excel file, let the user select the sheet to copy from, and then have the macro copy a range or column into the original excel file.

So Have Excel file #1 open. Launch Macro to select Excel file #2, user selects sheet, macro copies column/range to active Sheet of Excel File #1.

I've patched together some code from other threads and came up with something like this:

Please Login or Register  to view this content.

It lets me open the file, and select the sheet, but it copies the contents of the wrong sheet. I'm not exactly a vba guru, so ive been trying to figure this out for a while now with no results. Any help is much appreciated.

Thanks!

Wow nice! I like the fact that there's options to choose from when it comes to the sheets. Only problem I got with that is, sometimes I have 15+ sheets with similar names, and without actually going through them, it's can be difficult to tell which sheet is the right one to copy from. Either way much appreciated for the help! The code that ended up working for me is below:

Please Login or Register  to view this content.