The easiest way to transfer data from one place to another is simply to
highlight the cell which is to receive the data. Then hit "=" and with the
mouse go to the cell where the data is to transfer from. Click on "enter".
The cell with the = sign now reads the data from another cell.
This works even if the data is in another workbook. But both spreadsheets
must be open at the same time for the data to transfer.
Len

url:http://www.ureader.com/msg/10402624.aspx