using same data set on multiple worksheets

[eggerand]

i'm having trouble remembering how to set up a book so that the data
entered into one column on one worksheet will automatically be entered
into columns on other worksheets with in that book.

 

[Mark Lincoln]

Method 1: Select, say Sheet1, Sheet2, and Sheet3. Anything typed in a
cell in one of the sheets will also be entered in the same cell of the
other sheets.

Method 2: On, say, Sheet2, Cell A1, enter the formula:

=Sheet1!A1

This will make Sheet2's A1 equal Sheet1's A1.

 

[eggerand]

thanks! i knew it was something easy.