Simultaneous entry of data between 2 different worksheets

H

huggybear551

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!
 
T

Toppers

Would the following do?

say in B3 on sheet2 put

=Sheet1!A2

where A2 is a calculated cell in sheet1
 
Top