Text from one sheet cell to appear in another sheet cell

M

mduck

Is there a function or formula that I can put in a cell to grab tex
from a different sheet's cell? I'm working on a template for people t
use where they use different sheets in the same Excel file to provid
specific information. I want certain cells of info to automaticall
populate cells in the Overall Template plan sheet. So that by the tim
they are done completing all of the separate sheets, they will have on
master sheet that's already completed. Does this make sense? Any hel
you have, I would greatly appreciate it! There has to be an easy way t
do this, but I'm not finding it
 
F

FireGeek822

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
[email protected]
 
J

JE McGimpsey

If the text is in Sheet1, cell A1, then in your summary sheet, enter

=Sheet1!A1
 
L

lucasjackson

I just posted the same question and got the same good advice.

Now I'm wondering if there is a formula that will allow me to enter data
into sheet 2, and have it copy automatically into sheet 1 and 3, or into
sheet 3 going to sheet 1 and 2? So that I can enter the data into any sheet
and have it transfer to all sheets, rather than always from sheet 1 to sheets
2 and 3.
 
Top