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
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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies