Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 78
Default Seeing Linked Information

I am stumped as I do not know what is the best way to accomplish this action.
What I mean is with a formula or with VBA coding. So if this is in the
wrong forum, can it please be moved to the correct one? Thanks

What I need to do is by selecting a cell, have some corresponding
information pop up with some related information. This is for our GL account
listing.

Example: In A6 I have GL name as €śMotorcycle Parts Revenue€ť, so when I go to
cell A6, I want to see in a dropdown box to the right of this cell that lists
all of the reports that this GL account is linked to. And lets for this
example sake, say that there is five different financial reports that this
account is linked to.

Walter



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
I have 2 workbooks with linked information how do I merge them Eqa Excel Discussion (Misc queries) 3 March 25th 07 08:51 AM
Protected Sheet doesn't update linked information Trainmaster Excel Discussion (Misc queries) 3 March 16th 07 06:50 PM
How I do protect linked information if the link source is deleted moran Excel Worksheet Functions 2 October 25th 06 08:07 PM
How to keep linked cells blank until information is entered? HollyB Excel Worksheet Functions 1 April 1st 05 07:48 PM
Display references to linked information LBA Excel Worksheet Functions 2 December 10th 04 07:25 AM


All times are GMT +1. The time now is 06:08 PM.

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

About Us

"It's about Microsoft Excel"