copy cell from one sheet to another

L

lee254

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
 
P

pdberger

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 >Paste>Special 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
 
L

lee254

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.
 
P

pdberger

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
 
Top