Unique Situation

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.



#=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
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies