Use links:

Say we have two books open, Book1.xls and Book2.xls. We type data in
Book1, Sheet1, A1. In Book2, Sheet1, A1 use the formula:

=[Book1]Sheet1!$A$1

It will automatically pick up the value from Book1
--
Gary''s Student - gsnu200735


"Man" wrote:

Can someone please tell me is it possible to type information in one workbook
and have the same information also appear on another seperate workbook? Or do
you have to type the information in both files?