Macro copy data from sheet and insert.

[daniel.s]

Hi All,

I need a macro that will copy an entire sheet's data onto another sheet in another workbook.

Is this possible?

I have already created a macro that brings up a message box...then when I click 'OK' you navigate to the data source...its from here I need the data copied.

Many thanks indeed,

Daniel.

 

[daniel.s]

Perfect - its worked beautifully. Many thanks for your help!