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.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies