Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,388
Default linking sheets to summary Excel 2003

please help. I have a set of worksheets circa 100 from which I want to link
certain cells [same cells from each sheet] to a summary page in the same
workbook into seperate columns. The cells I want to link from are not next to
each other.

eg cell E8 sheet 100 to summary sheet D4, cell E16 sheet 100 to summary
sheet E4, cell E8 sheet 99 to summary sheet D5, cell E16 sheet 99 to summary
sheet E5

is there an easy way other then to insert the links manually?
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
LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS SSJ New Users to Excel 2 July 9th 07 03:13 AM
LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS SSJ Excel Worksheet Functions 2 July 9th 07 03:13 AM
Linking References from Multiple Sheets to One Summary Sheet Kim Setting up and Configuration of Excel 3 May 5th 05 04:56 PM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 08:13 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM


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