Lee --

Depends what you're trying to do. If you're trying to do it manually, then
open both workbooks. Select the source cell and use PasteSpecial to paste
just the value into the target cell in the other workbook.

If you're trying to automate it, then select the target cell in the target
workbook, start a formula by pressing =, and then select the source cell in
the source workbook. The formula in the target cell will automatically
create the link to the source cell. Only mini-problem: every time you open
the target workbook, it will prompt you to open the source workbook, and the
link won't work unless it's open.

HTH

"lee254" wrote:

I have a daily timesheet, I would like to be able to post the info from a
certain cell from the time sheet to another sheet which i have already
formated to calculate: wages, taxes, 401K,ect..
Source sheet and cell # are C:\besiforms\besireports\612timesheet!h22.
Destination is C:\besiforms\besireports\time