Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Gustin512
 
Posts: n/a
Default How to link cells in diff't workbooks that don't contain formulas

Help, please...

I believe that there is a way to link cells that are in different workbooks
that do not contain formulas, but I can't remember how, and I can't find the
answer in any of MS help options.

Anyone know how to do this?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

inserthyperlink

--
Regards,

Peo Sjoblom

(No private emails please)


"Gustin512" wrote in message
...
Help, please...

I believe that there is a way to link cells that are in different
workbooks
that do not contain formulas, but I can't remember how, and I can't find
the
answer in any of MS help options.

Anyone know how to do this?


  #3   Report Post  
paul
 
Posts: n/a
Default

in one workbook in the place where you want the link type= and then click on
the cell in the second worksheet,it will link value or text or formulas
resulting in a value
--
paul
remove nospam for email addy!



"Peo Sjoblom" wrote:

inserthyperlink

--
Regards,

Peo Sjoblom

(No private emails please)


"Gustin512" wrote in message
...
Help, please...

I believe that there is a way to link cells that are in different
workbooks
that do not contain formulas, but I can't remember how, and I can't find
the
answer in any of MS help options.

Anyone know how to do this?



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
link two workbooks Toinett Excel Discussion (Misc queries) 5 May 26th 09 06:35 PM
How do I link a cells formatting from one worksheet to another? ddepasquale Excel Worksheet Functions 0 July 26th 05 08:51 PM
assemble link from different cells and return value tastic96 Excel Worksheet Functions 2 June 27th 05 02:00 PM
How do I link several cells in a row together & sorting Siy Blue Excel Discussion (Misc queries) 1 May 18th 05 11:40 PM
How do I link two cells as to allow me to change the value in eit. jpvlvt Excel Discussion (Misc queries) 3 January 26th 05 02:28 AM


All times are GMT +1. The time now is 09:01 AM.

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"