[users] Re: set cell's value?

2011-07-04 Thread Andrew Douglas Pitonyak
On 07/04/2011 03:15 PM, Michael Adams wrote: On Tuesday 05 July 2011 05:29, James wrote: I want to put an 'x' in Calc cells based on whether another cell's date (totalincoming) is larger than a different cell's value. I started this macro but is there an easier way? How do I set a cell's value?

[users] Re: set cell's value?

2011-07-04 Thread Andrew Douglas Pitonyak
On 07/04/2011 01:29 PM, James wrote: I want to put an 'x' in Calc cells based on whether another cell's date (totalincoming) is larger than a different cell's value. I started this macro but is there an easier way? How do I set a cell's value? Well, off hand, i would say that you cannot depend

[users] Re: set cell's value?

2011-07-04 Thread Andrew Douglas Pitonyak
On 07/04/2011 01:34 PM, RA Brown wrote: James wrote: I want to put an 'x' in Calc cells based on whether another cell's date (totalincoming) is larger than a different cell's value. I started this macro but is there an easier way? How do I set a cell's value? REM * BASIC * ' put an

[users] Re: set cell's value?

2011-07-04 Thread James
On 07/04/11 15:15, Michael Adams wrote: On Tuesday 05 July 2011 05:29, James wrote: I want to put an 'x' in Calc cells based on whether another cell's date (totalincoming) is larger than a different cell's value. I started this macro but is there an easier way? How do I set a cell's value? I'd

[users] Re: set cell's value?

2011-07-04 Thread Michael Adams
On Tuesday 05 July 2011 05:29, James wrote: > I want to put an 'x' in Calc cells based on whether another cell's > date (totalincoming) is larger than a different cell's value. > I started this macro but is there an easier way? > How do I set a cell's value? I'd forget the macro and just use 'IF'

[users] Re: set cell's value?

2011-07-04 Thread James
On 07/04/11 13:34, RA Brown wrote: James wrote: I want to put an 'x' in Calc cells based on whether another cell's date (totalincoming) is larger than a different cell's value. I started this macro but is there an easier way? How do I set a cell's value? REM * BASIC * ' put an 'x'

[users] Re: set cell's value?

2011-07-04 Thread RA Brown
James wrote: > I want to put an 'x' in Calc cells based on whether another cell's date > (totalincoming) is larger than a different cell's value. > I started this macro but is there an easier way? > How do I set a cell's value? > > > REM * BASIC * > > ' put an 'x' in cells where total