Home

Unique Situation

159MLMF
Occasional Visitor

So I have a unique situation for excel.

I have one spreadsheet that I would like to have the formula's automatically applied to instead of having to put it into the spreadsheet everytime I use the template.

Second issue is that I am using two other spreadsheets to populate the template and the reference spreadsheet names change daily.

Here is an example

Spreadsheet one = Ref1Jan2019#1 

Spreadsheet two = Ref1Jan2019#2

Formula for the template or master spreadsheet is as follows.

=vlookup(g2,'[Ref#1]Sheet1'!$1:1048576,#,false)

=vlookup(g2,'[Ref#2]Sheet1'!$1:1048576,#,false)

#=the column I am refering to on that particular spreadsheet

 

Spreadsheets one and two change date based off the date the report is run.

 

So is there a way to automagically update the formula or am I destined to spend my time re-typing the formula in everytime I need to update the master spreadsheet or is there a better method to get the results?

 

Thanks in advance.

 

1 Reply
You can update the source from the Data, Edit Links button and clicking the "Change Source" button.