Using XL

P

Paul

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

Gord Dibben

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
 
X

xlmate

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
 
Top