using same data set on multiple worksheets

E

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.
 
M

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.
 
Top