Home

Updating cell value automatically monthly or weekly etc.

%3CLINGO-SUB%20id%3D%22lingo-sub-660720%22%20slang%3D%22en-US%22%3EUpdating%20cell%20value%20automatically%20monthly%20or%20weekly%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660720%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wondering%20if%20there%20is%20a%20way%20to%20update%20cell%20value%20automatically%20in%20certain%20period%20of%20time%2C%20for%20example%20monthly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20this%20because%20I%20want%20to%20keep%20track%20of%20Customer%20Lifetime%20Revenue.%20We%20get%20a%20certain%20commission%20for%20different%20apps%20and%20services%20from%20our%20customers%20and%20the%20amount%20is%20every%20month%20the%20same.%20So%20we%20want%20to%20know%20how%20much%20revenue%20we%20have%20got%20from%20a%20customer%20since%20the%20customer%20relationship%20started.%20We%20have%20hundreds%20of%20customers%20so%20it%20is%20very%20hard%20to%20manually%20add%20the%20same%20amount%20to%20couple%20hundred%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20just%20to%20be%20sure%20that%20my%20question%20is%20understood%20correctly%3A%3C%2FP%3E%3CP%3ECell%20value%20is%20now%20100%3C%2FP%3E%3CP%3EI%20want%20to%20add%2010%20to%20it%20every%20month%2C%20for%20example%20first%20day%20of%20the%20month.%3C%2FP%3E%3CP%3EAfter%206%20months%20the%20value%20would%20be%20160%20and%20after%201%20year%20it%20would%20be%20220.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20the%20same%20thing%20for%20all%20customers%20so%20there%20is%20couple%20hundred%20cells%20that%20needs%20to%20be%20automatically%20updated%20this%20way%20every%20month.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%20with%20Excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-660720%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660761%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20cell%20value%20automatically%20monthly%20or%20weekly%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660761%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F352565%22%20target%3D%22_blank%22%3E%40Cepi1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20understanding%20is%20that%20you%20can't%20do%20this%20with%20Excel%20alone.%26nbsp%3B%20You%20need%20some%20form%20of%20trigger%20mechanism%20outside%20of%20Excel.%26nbsp%3B%20Excel%20on%20its%20own%20cant%20launch%20itself%20and%20auto-execute%20code.%26nbsp%3B%20If%20you%20had%20this%20file%20in%20OneDrive%20or%20Office%20365%2C%20you%20could%20investigate%20about%20using%20the%20Excel%20actions%20to%20perform%20the%20update%20if%20it%20was%20in%20a%20table.%26nbsp%3B%20It%20would%20be%20easier%20if%20you%20had%20some%20data%20in%20a%20SharePoint%20list%20that%20Flow%20could%20easily%20update%2C%20and%20your%20Excel%20just%20pulls%20from%20that%20data%20list%20and%20refreshes%20automatically.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660829%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20cell%20value%20automatically%20monthly%20or%20weekly%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660829%22%20slang%3D%22en-US%22%3EIf%20your%20start%20date%20is%20in%20B2%2C%20you%20may%20use%20this%20formula%20in%20C2%20to%20calculate%20lifetime%20revenue%3A%3CBR%20%2F%3E%3DDATEDIF(B2%2CTODAY()%2C%E2%80%9Dm%E2%80%9D)*10%2B100%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660831%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20cell%20value%20automatically%20monthly%20or%20weekly%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660831%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20I%20must%20have%20misunderstood.%26nbsp%3B%20I%20thought%20the%20requester%20wanted%20that%20to%20happen%20without%20even%20opening%20Excel%20and%20that%20populated.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Cepi1
Occasional Visitor

Hi

 

I am wondering if there is a way to update cell value automatically in certain period of time, for example monthly.

 

I need this because I want to keep track of Customer Lifetime Revenue. We get a certain commission for different apps and services from our customers and the amount is every month the same. So we want to know how much revenue we have got from a customer since the customer relationship started. We have hundreds of customers so it is very hard to manually add the same amount to couple hundred cells.

 

So just to be sure that my question is understood correctly:

Cell value is now 100

I want to add 10 to it every month, for example first day of the month.

After 6 months the value would be 160 and after 1 year it would be 220. 

 

And the same thing for all customers so there is couple hundred cells that needs to be automatically updated this way every month. 

 

Is this possible with Excel?

3 Replies

@Cepi1 

 

My understanding is that you can't do this with Excel alone.  You need some form of trigger mechanism outside of Excel.  Excel on its own cant launch itself and auto-execute code.  If you had this file in OneDrive or Office 365, you could investigate about using the Excel actions to perform the update if it was in a table.  It would be easier if you had some data in a SharePoint list that Flow could easily update, and your Excel just pulls from that data list and refreshes automatically.  

If your start date is in B2, you may use this formula in C2 to calculate lifetime revenue:
=DATEDIF(B2,TODAY(),”m”)*10+100

@Twifoo 

 

Sorry I must have misunderstood.  I thought the requester wanted that to happen without even opening Excel and that populated.  

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 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
29 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies