Link cells between two worksheets

[george]

Hi,

How do I link cells in sheet 2 to cells in sheet 1? I want data entered in
cells in sheet 1 be placed in cells in sheet 2.

Thanks

 

[Guest]

Say you want data from cell A1 in Sheet 1 to copy to cell B1 in Sheet 2. In
Sheet 1, cell A1, click on the cell and type an equal sign (=), then click on
Sheet 2, cell B1 and hit enter. That should take care of it for you.

 

[Bruce Sinclair]

Say you want data from cell A1 in Sheet 1 to copy to cell B1 in Sheet 2. In
Sheet 1, cell A1, click on the cell and type an equal sign (=), then click on
Sheet 2, cell B1 and hit enter. That should take care of it for you.

... or copy the cell you want to link, move to where you want to put the
link and 'paste special/link'.

Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)