how can information entered in one worksheet automatically show/display in
another worksheet?
--
Lori Evans

Lori Evans wrote...
how can information entered in one worksheet automatically
show/display in another worksheet?

If you enter something in SheetA!X99 and want it to appear in SheetB!
Y100, you have two choices:

Formulas - move to SheetB!Y100 and enter the formula =SheetA!X99 ;

Picture Links - move to SheetA!X99 and press [Ctrl]+C to copy it, then
move to SheetB!Y100, hold down a [Shift] key and click on Edit in the
menu bar, then click on Paste Picture Link.

The advantage of formulas is that you can use their result values in
other formulas. The advantage of picture links is that they update
immediately and automatically even under manual recalculation.

That's pretty simple.

You have a syntax for refering Other workbooks and other worksheets.
Workbook name (along with path) can be enclosed in square brackets []
Worksheet name can be followed by Exclamation Mark
Wherever there are spaces in names, the string should be enclosed in Single
quotes ''
Example Enter this in a cell in your sheet:
= [C:\MyWorkBook.xls]FirstSheet!A4
Will always display the same value as in A4 cell of FirstSheet in
MyWorkbook.xls located in C:\

You can omit the workbook name if the sheet refered to is in the same book.

In a cell on target worksheet enter this formula..........

=Sourcesheet!A1


Gord Dibben MS Excel MVP

On Mon, 16 Apr 2007 11:46:10 -0700, Lori Evans
wrote:

how can information entered in one worksheet automatically show/display in
another worksheet?