Lee --

I think the answer to your question is "yes, but...". As you've discovered,
you can set up your 'target' workbook to interrogate the 'source' workbook
every time it's opened. That's not quite the same as automatically writing
to the target workbook every time you enter new data in the source. The only
way I can think of doing THAT would be to write a macro that, evey time you
enter information in a specific field, opens up another workbook and writes
to it. The language for that is called VBA, and it sounds like a pretty
simple problem for someone who knows it. I don't, though. If you want to
pursue it, I'd go to the programming area on this web page.

HTH

"lee254" wrote:

thanks for the help, your suggestion worked as expected. but...that leads to
another question. i am trying to make this an automated process, so, is it
possible to enter the information in the cell in the timesheet, and have it
automaticaly enter the same information on the other sheet?
again, thanks for your help and your time, its appreciated.

"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