Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 31st 05, 04:50 PM
Church Administrator
 
Posts: n/a
Default excel contents cells on different worksheet like a comment

I am using excel as a database with multiple worksheets containing different
data some of which is related. I would like to view the contents of a range
of cells on one worksheet in a different worksheet such as a comment
function. Worksheet (a) would contain a name and serial number [a range of
four cells] and worksheet (b) would contain the same serial number but not
the name. So as I look at the serial number in a cell on worksheet b if I
place my cursor on that cell then a visual link or comment would appear
showing me the name on worksheet a.

  #2   Report Post  
Old August 31st 05, 08:48 PM
Dave Peterson
 
Posts: n/a
Default

Any chance you can just use another cell and either =vlookup() or
=index(match())?

You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

For more info.

Church Administrator wrote:

I am using excel as a database with multiple worksheets containing different
data some of which is related. I would like to view the contents of a range
of cells on one worksheet in a different worksheet such as a comment
function. Worksheet (a) would contain a name and serial number [a range of
four cells] and worksheet (b) would contain the same serial number but not
the name. So as I look at the serial number in a cell on worksheet b if I
place my cursor on that cell then a visual link or comment would appear
showing me the name on worksheet a.


--

Dave Peterson


Reply
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
Excel worksheet linking Shiren Excel Worksheet Functions 0 July 6th 05 05:33 PM
How can I protect an excel worksheet containing filters? JMcG Excel Discussion (Misc queries) 4 April 13th 05 03:13 PM
Excel shifts to wrong worksheet automatically Tom77 Excel Worksheet Functions 1 February 24th 05 08:10 PM
How to make empty cells as zero in excel add-ins for SQL Server an Microlong Excel Worksheet Functions 0 January 12th 05 06:31 AM
Need to remove a password that noone placed on Excel worksheet. tuffy1104 Excel Worksheet Functions 2 January 2nd 05 07:12 PM


All times are GMT +1. The time now is 05:10 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017