ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I link from a master spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/154300-how-do-i-link-master-spreadsheet.html)

uofu

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?

Tim879

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?




Ron de Bruin

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?



All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com