LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
govtmule
 
Posts: n/a
Default How do I hyperlink a value so it will show the value on another sh

I am creating a budget with several different sheets. The first sheet is an
overview of the budget. What I want to do is link the balance of each sheet
to the budget overview sheet so that the remaining balance value will show on
the overview sheet. Now is this possible? I have hyperlinked them but that
won't allow the value to change on the overview sheet, also I tried
referenceing the cell but Excel won't allow me to reference another cell on
another sheet. I'm not very experienced with Excel so I'm just trying to
experiment here. Any help would be appreciated.
 
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
Moving rows with Hyperlink doesn't move hyperlink address Samad Excel Discussion (Misc queries) 15 June 22nd 06 12:03 PM
answer to odd results when comparing hyperlink addresses Patricia Shannon Links and Linking in Excel 0 March 9th 06 07:28 PM
How do I emulate rightclick on a hyperlink in an Excel Macro Emulate RightClick on Hyperlink in Macro Excel Discussion (Misc queries) 0 January 2nd 06 08:40 AM
Show values from other sheet TONY Excel Worksheet Functions 0 August 31st 05 03:03 PM
Removing hyperlink Frank Marousek Excel Discussion (Misc queries) 3 January 12th 05 09:53 PM


All times are GMT +1. The time now is 05:47 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"