Simultaneous entry of data between 2 different worksheets

  • Thread starter Thread starter huggybear551
  • Start date Start date
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!
 
Would the following do?

say in B3 on sheet2 put

=Sheet1!A2

where A2 is a calculated cell in sheet1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

merging data/worksheets 1
Copy from worksheet to worksheet 3
Absolute References and worksheets 0
One worksheet to calulate different items simultaneously 4
How do I count instances of a reference? 1
Formulas that recognise data from two worksheets 1
How to Auto Reference Worksheet Tab ID's in Formulas? 9
calculate percentage from cells in different worksheets 1

Back
Top