LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
denny
 
Posts: n/a
Default Travelling from a formula to its source

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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Again-revealing the contents of formula srinivasan Excel Worksheet Functions 0 July 5th 05 06:25 AM
Data Source Name Not Found Justin Tyme Excel Worksheet Functions 0 June 16th 05 11:45 PM
Need Formula to display pivot table source data Don S Excel Worksheet Functions 3 February 23rd 05 10:13 PM
Formula Result Correct but value in the cell is wrong jac Excel Worksheet Functions 2 December 17th 04 08:05 PM
How do I use Range Names listed in a VLookup table in a formula? Essbasedvlpr32 Excel Worksheet Functions 3 December 15th 04 10:11 PM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"