Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Massive link update
I'm working with three diferent files for quoting, the summary page, the
quote calculator, and the master data sheet. The summary file (1 file) is 200 lines long with linked information from each of the 200 quotes (200 files), that are all linked to the master data file (1 file). What I need is that when the master data file is updated, all 200 quote files are updated without going in each quote files and update manually. Summary file <-- 220 quote files <--- master data file. Thanks for the help Chimi |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Massive link update
Try the below in your master sheet
'Reference to Sheet2 cell C3...Once you copy the formula; try and insert rows/cols in Sheet2. and retry.. =HYPERLINK("#"&CELL("address",Sheet2!C3),"target") If this post helps click Yes --------------- Jacob Skaria "Chimi" wrote: I'm working with three diferent files for quoting, the summary page, the quote calculator, and the master data sheet. The summary file (1 file) is 200 lines long with linked information from each of the 200 quotes (200 files), that are all linked to the master data file (1 file). What I need is that when the master data file is updated, all 200 quote files are updated without going in each quote files and update manually. Summary file <-- 220 quote files <--- master data file. Thanks for the help Chimi |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Massive link update
Hi Chimi
Please ignore my previous post...For your query; take a look at help on VLOOKUP(). If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below in your master sheet 'Reference to Sheet2 cell C3...Once you copy the formula; try and insert rows/cols in Sheet2. and retry.. =HYPERLINK("#"&CELL("address",Sheet2!C3),"target") If this post helps click Yes --------------- Jacob Skaria "Chimi" wrote: I'm working with three diferent files for quoting, the summary page, the quote calculator, and the master data sheet. The summary file (1 file) is 200 lines long with linked information from each of the 200 quotes (200 files), that are all linked to the master data file (1 file). What I need is that when the master data file is updated, all 200 quote files are updated without going in each quote files and update manually. Summary file <-- 220 quote files <--- master data file. Thanks for the help Chimi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Massive Find and Replace | Excel Discussion (Misc queries) | |||
search massive | Excel Worksheet Functions | |||
Pivot Cache - Massive Spreadsheet | Excel Discussion (Misc queries) | |||
Recalculation taking a massive 11 seconds | Excel Worksheet Functions | |||
Recalculation taking a massive 11 seconds | Excel Worksheet Functions |