copy sheets values

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hello everyone,

i have a question;

Is it possible to copy values (A2:Z500) from a sheet name "Data" in a
worksheet name "BdData.xls" to an other worksheets but not in the same
folder as the first, and in this worksheet name "BbData.xls" values would be
in the sheets "Data".

Thanks a lot for all your advices.

Michael
 
Yes.

Open both files and use Edit|Copy (xl2003 menus) to copy the range.

Go to the other worksheet in the other workbook and select the top left cell of
the destination range.

Then Edit|Paste (or Edit|Paste special|values).

If you need a macro, you could record one while you're doing it manually.
 
Back
Top