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?
+1
A:
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?
Charles Williams
2010-07-15 16:40:35
+3
A:
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.
Ben Hoffstein
2010-07-15 16:40:37
+1
A:
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
Vasil Dakov
2010-07-15 16:53:40