auto update between sheets?

J

Jay

Hello does any one know a way to get a value from one sheet to automatically
change a value in another sheet. Example I have a total at A65 that is
changing daily, I would like the value at A65 to automatically put it self
on say sheet 2 in B5. Any suggestions. Thank you
 
J

J.E. McGimpsey

Cells can't "push" their value to other cells. Rather you should
"pull" the results you want by using this in Sheet2!B5:

=Sheet1!A65
 
J

Jay

Thank you for your help!


J.E. McGimpsey said:
Cells can't "push" their value to other cells. Rather you should
"pull" the results you want by using this in Sheet2!B5:

=Sheet1!A65
Click to expand...
 

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

Turning off automatic calculation 0
External cell reference between two excel worksheets both in One Drive 0
Lookup whole sheet and add datas from specified date to end date 0
Sumproduct giving #Value error 5
Many sheets, one DB? 1
Excel Formula or VBA Code 2
Auto Change Formulas - Please Help. 2
Sub projects added as read only in Master file which are saved on sharepoint 1

Top