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.
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.
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.
thanks! i knew it was something easy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks