Using XL
 

How do I get the same informationton to automatically transfered to another
sheet using an old version of XL.

Using XL
 

See help on "linking'

Basics.................on sheet2 type an = sign in a cell.

Switch to sheet1 and select a cell. Hit the ENTER key.

You are now linked.


Gord Dibben MS Excel MVP

On Sun, 22 Feb 2009 09:34:01 -0800, Paul
wrote:

How do I get the same informationton to automatically transfered to another
sheet using an old version of XL.

Using XL
 

try

1) Click on sheet tab you want to transfer to another workbook
2) Place your mouse on the sheet tab and right click
3) Choose Move or Copy
4) Under the To book, Select the workbook name you want to move the sheet to
( Note the target workbook must be open, if you want to move to a new
workbook, just choose new book from the drop down )
5) click OK

This will move the sheet to the new workbook
--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis










"Paul" wrote:

How do I get the same informationton to automatically transfered to another
sheet using an old version of XL.