#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Excel workbook links

Is there a way to link a specific worksheet in a workbook to a different
workbook? I have a summary workbook that links to separate job workbook. Each
job workbook has multiple worksheets. I want the first worksheet in each job
workbook to be linked to a summary workbook. The summary workbook will have a
worksheet for each linked job first worksheet. Does that make sense?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 248
Default Excel workbook links

You want to link all the cells in a worksheet to cells in another worksheet
in another workbook?

Select the source range, say A1:Z100, Copy the range
Go to the cell A1 in your destination sheet and choose Edit-Paste
Special-Paste Link
-------------------------------------
Pl. click ''Yes'' if this was helpful...
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
Looking for help with excel workbook links Tatu Excel Discussion (Misc queries) 0 February 27th 09 01:32 PM
Excel Worsheet/Workbook formula links CrossCutter Excel Discussion (Misc queries) 1 December 9th 08 01:18 AM
Emailing an Excel Workbook with Links Frank G Links and Linking in Excel 2 June 29th 07 03:54 PM
Emailing an Excel Workbook with Links Frank G Excel Discussion (Misc queries) 0 April 11th 07 07:46 PM
hyper links not working in Excel workbook Skip Bisconer Excel Discussion (Misc queries) 1 April 20th 06 06:51 AM


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