O.K
First, I'm sorry that I didn't provide al the necessary details.

When I say "all the active cells", I mean : ROW 1 and 2, because row 3 has no values.

A B
ID NAME

1 555 James


2 444 Rooney

3

There is the first xslx file(Names) and the second is also xlsx file(Orders).
both are xslx.
The "Names" file is not open ,while the "Orders" file is Open.
I want to copy the data from the Names to the orders.
I want to copy the data to the first row that does not contain data in Orders file.

Thanks.