Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I link from a master spreadsheet?

I have created a master template that I will be using several times. I want
to link information from this template to a summary workbook. However, the
information I want linked will come from different versions of the template.
Example, when I want to use the template, I will "save as" as a new name. Is
there some way to do this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 208
Default How do I link from a master spreadsheet?

You may be able to find your answer he
http://www.rondebruin.nl/txtcsv.htm


On Aug 15, 2:34 pm, uofu wrote:
I have created a master template that I will be using several times. I want
to link information from this template to a summary workbook. However, the
information I want linked will come from different versions of the template.
Example, when I want to use the template, I will "save as" as a new name. Is
there some way to do this?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default How do I link from a master spreadsheet?

Hi uofu

Try this example to create links to the cells in each workbook in a folder
http://www.rondebruin.nl/summary2.htm

You can also copy
See
http://www.rondebruin.nl/copy3.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"uofu" wrote in message ...
I have created a master template that I will be using several times. I want
to link information from this template to a summary workbook. However, the
information I want linked will come from different versions of the template.
Example, when I want to use the template, I will "save as" as a new name. Is
there some way 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 Worksheets Into Master PolQueen Excel Discussion (Misc queries) 5 June 20th 07 10:40 PM
Link different worksheets in different workbooks to 1 master workb Anthony Excel Discussion (Misc queries) 2 July 20th 06 09:57 AM
How do I link password protected files to a master spreadsheet? Laurie M. Excel Worksheet Functions 1 July 17th 06 10:50 PM
Link Worksheets to a Master Sheet Reefaman Excel Worksheet Functions 0 March 1st 06 07:19 PM
how do i link a number of worksheets to one master worksheet? Rusty Excel Worksheet Functions 0 January 24th 05 08:49 AM


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