In worksheet A i have some cells that change when naother cell has its data
changed

i need to copy these cells into another worksheet- how can i do this? when
the data fields change in the original worksheet i need them to change in
the newer worksheet

thanks

The easiest way is to:
Right click in the cell that you want to copy,
Click on "Copy",
Navigate to the other sheet, and right click in the cell that you want to
"receive" the data,
Click on :Paste Special",
Then click on "Paste Link", then <Esc, and you're done!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"mo" wrote in message
...
In worksheet A i have some cells that change when naother cell has its data
changed

i need to copy these cells into another worksheet- how can i do this? when
the data fields change in the original worksheet i need them to change in
the newer worksheet

thanks