Try the macro recorder.


Gord Dibben MS Excel MVP

On Thu, 7 Jan 2010 09:14:02 -0800 (PST), Norvascom
wrote:

I would like to create a macro that would do the following:

1- Open a closed Excel file located on my drive named "A" and select
the sheet named "Sheet1"
2- Copy all data from this sheet starting on cell A1 to the already
opened master Excel file named "B" on sheet named "Sheet2" cell A1.

Thanks in advance for your help.