Transferring cell info to another spreadsheet

S

Susan

Can a spreadsheet be setup to select a cell and have that info transferred to
another spreadsheet without using copy and paste.
 
S

S3NTYN3L

If your just wanting to display the result of a cells contents into
another sheet try this:

Let's say you have data in cell A1 on sheet1 and you want it in cell B1
on sheet2...

You would put the following into cell B2 on sheet2:

=Sheet1!A1

Any data in cell A1 on sheet 1 will now be displayed in cell B2 on
sheet2.


Hope this helps you...
 
Top