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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies