Simultaneous entry of data between 2 different worksheets

[[email protected]]

I would like for some calculated results from cells in one worksheet to
automatically be entered into similar cells in a different worksheet.
As it stands now I have to transfer the data by hand each month, making
the data much more susceptible to error. How can I do this? Thanks!

[Toppers]

Would the following do?

say in B3 on sheet2 put

=Sheet1!A2

where A2 is a calculated cell in sheet1



"[email protected]" wrote:

> I would like for some calculated results from cells in one worksheet to
> automatically be entered into similar cells in a different worksheet.
> As it stands now I have to transfer the data by hand each month, making
> the data much more susceptible to error. How can I do this? Thanks!
>
>