Linking cells in same Excel spreadsheet

开发者_Python百科In Excel, how can I set up a spreadsheet so when I type in one cell it will populate another cell in the same spreadsheet?

I'll field this one.

If you want the contents of, say, C1 to mirror the contents of cell A1, you just need to set the formula in C1 to =A1. From this point forward, anything you type in A1 will show up in C1 as well.

Well the simplest way is to have a formula in Z99 =B4 so that when you type in B4 Excel will copy the value to Z99.

But maybe thats not what you are looking for?

If you want to use the example of Ben Hoffstein between two spreadsheets (cell from Sheet1 to Sheet2) you should use the formula =Sheet1!A1

=Value(Click on cell you want to match assuming it's a number)

Copy, Paste Formula along column or row or array