Hi,
you can have formulas in the 2nd spreadsheet. enter in sheet 2 cell a1 this
and them copy it

=sheet1!a1



"AngelEyes" wrote:

how do i copy data from one sheet to another so that if the info changes on
the first sheet it will automatically change on the second?