Re: $$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Paul Schreiner
you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Enock Wangila >To: excel-macros@googlegroups.com >Sent: Wednesday, February 11, 2015 10:13 AM >Subject: Re: $$Excel-Mac

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Enock Wangila
I have no VBA coding experience. Could you refer me to a resource that I can use to write the command or a better alternative. On 2/11/15, Paul Schreiner wrote: > Sorry, EXCEL functions cannot act on other cells. > > If you wanted to write a VBA macro, then this could be done. > You could even

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Paul Schreiner
Sorry, EXCEL functions cannot act on other cells. If you wanted to write a VBA macro, then this could be done. You could even make it an "event" macro on "Worksheet one" such that when the values in the two cells change, "worksheet two" automatically updates. Paul -

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Paul Schreiner
Hmm.. your question and expectations are unclear. a "formula" technically is an equation that may or may not contain functions. =TODAY() + 3 is a formula that uses the TODAY() function to calculate the date 3 days from the current date. >From your question, you want to insert a specified val