You could link the two workbooks.
Go to workbook one. Go to an empty cell. Key "+" (or "=") and then go into
the second workbook and select the cell you want linked.
You can then copy the formula if you want other cells linked to the same
workbook.
Of course, it will be done on a relative basis.
Hope that's what you were asking.


"jr" wrote:

well, i go two workbooks, i'm trying to update one workbook using the
contents of the second one. i guess i could use copy and paste, would anyone
have a better and less time consuming option?