> Hat wrote:
> Thanks, given the head cold I'm getting over I'm well due for a RTFM.
>
pffft. Given TFM is a MSFM it's also a POS so not your fault. They
might as well just put random characters in there.
~|
Want to reach the
> If you want to get automatic updates of the other users' changes
> periodically, with or without saving, click Share Workbook on the
> Tools menu, click the Advanced tab, and under Update changes, click
> the options you want.
>
> or...
> another way round it may be to set the Update Changes opt
>From Excel help:
If you want to get automatic updates of the other users' changes
periodically, with or without saving, click Share Workbook on the
Tools menu, click the Advanced tab, and under Update changes, click
the options you want.
or...
another way round it may be to set the Update Chang
I figure with the expanse of knowledge on this list somebody's got to
have an answer to this question:
We track one of our main routines using a shared excel spreadsheet
that is updated by various employees. It is set up at the moment so
that changes appear whenever an employee saves the file.
> You could easily generate this using ColdFusion while outputting an HTML
> table.
true.
> However, in Excel, you should be able to click the little black box in
> the bottom-right corner of a highlighted cell and drag it down. The
> cell references in the formula should update to the new loca
not what it is doing?
M!ke
-Original Message-
From: William Bowen [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 17, 2005 11:03 AM
To: CF-Community
Subject: An excel question
I have the following formula in cell G2 in a spreadsheet.
=CONCATENATE(B2,"-",C2,"-",D
n/m - found the answer!
thanks!
On Thu, 17 Feb 2005 09:02:44 -0800, William Bowen
<[EMAIL PROTECTED]> wrote:
> I have the following formula in cell G2 in a spreadsheet.
>
> =CONCATENATE(B2,"-",C2,"-",D2,"-",E2,"-",F2)
>
> It works as expected on row 2.
>
> Now here is the problem. If I add a R
I have the following formula in cell G2 in a spreadsheet.
=CONCATENATE(B2,"-",C2,"-",D2,"-",E2,"-",F2)
It works as expected on row 2.
Now here is the problem. If I add a Row 3, I have to enter (usually
copy/paste) this formula again. and then edit the formula to be:
=CONCATENATE(B3,"-",C3,"-",D
How does one do a sum from COL:ROW to COL:inifinity? Ie, I want the sum
of column A, starting from row 2, and going on until till the end. I
know I can just put in A2:A99 but I want something better.
===
Raymond Camden, ColdF