Master workbook to pull data from second workbook into seperate sheet

Hi,

I have a workbook (master) with a Macro Button that I'd like to press to open the 'file open dialogue box' ,allow me to select another workbook (temp), and copy the contents of "temp:sheet1" into "master:sheet2'".

I can get this to work by recording the macro, however it doesn't allow me to change which file I open. I'd like the option to select.

Any help would be much appreciated.

Dave

Thanks for the quick response. I pasted in the code you offered and I get a 'run time error' at this point:

Please Login or Register  to view this content.

Do i need to alter the names of the sheets in the code to match what mine are written,

i.e. sheet1


thanks
Dave

I should have tried it before posting back, got it to work. Thanks again for the swift response.

Hello Djm,

Can you please attach the excel workbook with the solution. That will very helpful.

Thank you

Book1.xlsb

Here is the workbook for those of you who are interested.

Alter the ranges in the following line of VBA code to match your requirements:

Please Login or Register  to view this content.

Regards,

Dave

Hello Djm,

How does your workbook works? I only see a button. Can you please explain. Thank you!

Hi Naja,

I was after a workbook with a macro that when pressed would prompt you for another workbook and copy the data from Sheet1 in that workbook and paste it into sheet2 on the master workbook. Thus eliminating the need to open two workbooks, highlight the data and paste it in.
Whilst the workbook is open, press Alt F11, find this line of code:

Please Login or Register  to view this content.

alter the code to match the names of your sheets and the range. Currently this code will only copy whatever is written cell A1 from sheet1 wkbook2 into sheet2 wkbook1.

Hope this helps.

Any problems, feel free to message