copy a cell from sheet 1 to sheet 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to copy the result in cell M75 - Sheet 1 to cell F8 in sheet 2
(same workbook)

Need the formula.

Thanks,

Bob M.
 
Thanks for the reply, one problem. When new numbers are entered into Sheet
1, they are updated on Sheet 1 but not on Sheet 2. Ideas?

Bob M.
 
On Sheet1, in M75, enter
100

On Sheet2, in F8, enter just an equal sign
=

Go back to Sheet1, and click in M75, and hit <Enter>

You should automatically be transported back to Sheet2, and you should see
that 100 displayed in F8.

Did that work?
 
If you have entered the formula in Sheet2 F8 and value doesn't change when you
enter a new number in Sheet1 then I would check to make sure calculation mode is
in Automatic.

Tools>Options>Calculation


Gord Dibben MS Excel MVP
 
This works! I still have some other numbers to enter. Will shout if I have
a problem.

Thanks,

Bob m.
 

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

Complex formula help , please. 13
Copy Sheet to new Sheet and clear cells on original sheets 7
Excel VBA to move cells to sheet2 based on selection in sheet1 0
problems getting this macro to work 23
Begging for VBA Help ASAP! 6
change formula- keep cell increment sheet numbers 3
Excel Move or Copy Stopped Working? 0
Populate Data from Summary Sheet 5

Back
Top