How do I automatically transfer data in one cell to another cell on same sheet in Excel 2007?

How do I automatically transfer data in one cell to another cell on same sheet in Excel 2007 Asked by Lindab130 3 months ago Similar questions: automatically transfer data cell sheet Excel 2007 Consumer Electronics > Cell Phones & Accessories.

Similar questions: automatically transfer data cell sheet Excel 2007.

Consumer Electronics > Cell Phones & Accessories.

Create a formula in one sell that simply refers to the other cell. For example, if you want cell C5 to always have a copy of the data that's in cell E9, then in cell C5, type:=E9Then whenever you change what's in E9, C5 will change as well.

After lots of trial in error, that is exactly what I did! It works great. I was making a financial statement for our Church and numbers and I don't always get along.So now it is mostly a fail-proof document for adding things up correctly.

Thanks for your help. Seems simple now, but sure kicked my rear for about an hour! God Bless!

Lindab130 3 months ago .

Excel 2007. " "Use of mobile (cell) phones on planes, are you for or against?" "Excel 2007, selecting find, want the cell it finds to highlight in a different color then the default grey? " "where to buy used cell phones" "How do unlocked cell phones work?

" "why don't cell phones use standard batteries?

In Excel, Sheet Day(1),cell Total transferred to Day(2), cell Previous Total, then when Imake a new sheet transfer total.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.