moving values from one sheet to another

  • Thread starter Thread starter makdaddy925
  • Start date Start date
M

makdaddy925

I am working on a business spredsheet and would like to create a formula
in a sheet (say sheet 2) and the value that returns I would like to copy
that value to another sheet the main sheet (sheet 1). So when I make
changes and update sheet 2 the value will change and the new updated
value will auto copy to the main sheet and auto update those values. Is
this possible? And how do I create that? Thank you.
 
Hi!

Suppose you have this formula on Sheet2 in cell A1:

=SUM(B1:B10)

You want the result of that formula to also appear on Sheet1 in cell A1.
Enter this formula in cell A1 of Sheet1:

=Sheet2!A1

Biff

"makdaddy925" <[email protected]>
wrote in message
news:[email protected]...
 
Thank you for the reply. I will try to use that info. Another question
about your suggestion. will I be able to use that in another formula on
Sheet 1?
 

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

moving values from sheet to another 1
Count the columns from one sheet and paste it in another sheet 0
Excel Move or Copy Stopped Working? 0
VBA: How can I use a string variable as autofilter criteria? 4
Moving data from one sheet to another 2
Pull value from another sheet 3
adding amounts if criterias are met 1
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10

Back
Top