View Single Post
  #2   Report Post  
FireGeek822
 
Posts: n/a
Default Text from one sheet cell to appear in another sheet cell

Here are a couple formulas:

1 Workbook, Multiple sheets
In Sheet 2, select a cell for information from Sheet 1. Type the
following function:
=Sheet1!B1

2 Workbooks, Multiple sheets
In Sheet 1 of Workbook 2, select a cell for information from Workbook
1, Sheet 1, Cell E8. Type the following function:
=[Book1.xls]Sheet1!$E$8

TIP: If you have both workbooks open at the same time, scale the
windows to have them side by side. Click on a cell in Book2 and type =
then click your mouse in Book1 and the cell you desire. The formula
will populate automatically.

Hope this helps.

Tammy