data transfer

D

dave242006

I created two work sheets. When i put data into sheet one I want it to be
able to automatically copy the same data from selected cells in sheet 1 to
sheet 2
Is this possible ???
If so can anyone help me out here
 
P

pdberger

Dave --
Let's say the 'source' cell (where you type the data) is on Sheet 1, cell
A1. The 'target' cell (where you'd like Excel to update it) is on Sheet 2,
cell B2.

In the 'target' cell, type:

='Sheet1'!A1

HTH
 
Top