Subject was--Drawing info from another page.
I don't know how to hook on a add-on question so I am attaching the original
questions. Maybe Excel just doesn't have the feature, but let me illustrate
so you are sure you understand me.

Make 2 Excel sheets in a worksheet or 2 separate files. Call one Names and
one Numbers. Type "Jimmy" in the Sheet called Names in cell A1. In cell B2,
type "82" .
Now in Numbers Cell F1 type "=" and then mouse click on Names. Find cell
B2. Press Enter. That puts the number (82) in Names A2 into Numbers F2.
But supposing you had each new name and number coming from other files, it
would be hard to check their sources without painstakingly searching each one
out In Lucid you could sit on F1 and press "+" and it would take you to the
source of the formula (zip, bang, boom...pronto, bonto).
********
Similar answer by Gord and Dave--By "pages" do you mean spreadsheet tabs?
There is a keyboard shortcut for switching between tabs: simultaneously press
CTRL PG-UP or CTRL

Excel can 'gather' and update info into a formula, and use hyperlinks, but I
had a Dos program called LUCID that could not only gather the information,
but you could travel back and forth between the pages by using the <+ or
<-. Is there any shortcut like that in Excel?

denny

Select your linked cells.

ToolsFormula AuditingTrace Dependents.

Alternatively.......in ToolsOptionsEdit turn off(uncheck) "edit directly in
cell".

When you double-click a cell you will be sent to the source.


Gord Dibben Excel MVP

On Tue, 5 Jul 2005 13:14:01 -0700, "denny"
wrote:

Subject was--Drawing info from another page.
I don't know how to hook on a add-on question so I am attaching the original
questions. Maybe Excel just doesn't have the feature, but let me illustrate
so you are sure you understand me.

Make 2 Excel sheets in a worksheet or 2 separate files. Call one Names and
one Numbers. Type "Jimmy" in the Sheet called Names in cell A1. In cell B2,
type "82" .
Now in Numbers Cell F1 type "=" and then mouse click on Names. Find cell
B2. Press Enter. That puts the number (82) in Names A2 into Numbers F2.
But supposing you had each new name and number coming from other files, it
would be hard to check their sources without painstakingly searching each one
out In Lucid you could sit on F1 and press "+" and it would take you to the
source of the formula (zip, bang, boom...pronto, bonto).
********
Similar answer by Gord and Dave--By "pages" do you mean spreadsheet tabs?
There is a keyboard shortcut for switching between tabs: simultaneously press
CTRL PG-UP or CTRL

Excel can 'gather' and update info into a formula, and use hyperlinks, but I
had a Dos program called LUCID that could not only gather the information,
but you could travel back and forth between the pages by using the <+ or
<-. Is there any shortcut like that in Excel?

Ah, hah!! We're making progress...but can we come back again to the cell we
started from?
....and what does this mean? I got the next line of instruction, but not
this one.
ToolsFormula AuditingTrace Dependents.


"Gord Dibben" wrote:

denny

Select your linked cells.

ToolsFormula AuditingTrace Dependents.

Alternatively.......in ToolsOptionsEdit turn off(uncheck) "edit directly in
cell".

When you double-click a cell you will be sent to the source.


Gord Dibben Excel MVP

On Tue, 5 Jul 2005 13:14:01 -0700, "denny"
wrote:

Subject was--Drawing info from another page.
I don't know how to hook on a add-on question so I am attaching the original
questions. Maybe Excel just doesn't have the feature, but let me illustrate
so you are sure you understand me.

Make 2 Excel sheets in a worksheet or 2 separate files. Call one Names and
one Numbers. Type "Jimmy" in the Sheet called Names in cell A1. In cell B2,
type "82" .
Now in Numbers Cell F1 type "=" and then mouse click on Names. Find cell
B2. Press Enter. That puts the number (82) in Names A2 into Numbers F2.
But supposing you had each new name and number coming from other files, it
would be hard to check their sources without painstakingly searching each one
out In Lucid you could sit on F1 and press "+" and it would take you to the
source of the formula (zip, bang, boom...pronto, bonto).
********
Similar answer by Gord and Dave--By "pages" do you mean spreadsheet tabs?
There is a keyboard shortcut for switching between tabs: simultaneously press
CTRL PG-UP or CTRL

Excel can 'gather' and update info into a formula, and use hyperlinks, but I
had a Dos program called LUCID that could not only gather the information,
but you could travel back and forth between the pages by using the <+ or
<-. Is there any shortcut like that in Excel?