>I need help with formulas, or a math function.
>
[quoted text clipped - 4 lines]
>
> Thank You
Great, that seems pretty simple.
Is there a simple way to replicate that formula so I could use it without
having to specify the exact Colum/Row?
Meaning I need to do what I originally asked, but need to duplicate that
function, down multiple colums across multiple sheets.
> >I need help with formulas, or a math function.
> >
[quoted text clipped - 6 lines]
>
> In cell B2 type "=A2-A1" (without the quotes)
Peo Sjoblom - 19 Jul 2007 20:10 GMT
Copy the formula by grabbing the lower right corner of the cell and copy it
down

Signature
Regards,
Peo Sjoblom
> Great, that seems pretty simple.
>
[quoted text clipped - 14 lines]
>>
>> In cell B2 type "=A2-A1" (without the quotes)
gls858 - 19 Jul 2007 20:34 GMT
> Copy the formula by grabbing the lower right corner of the cell and copy it
> down
Peo answered first part on how. Here's how to do it across
multiple sheets:
To do it across multiple sheets group the sheets first then
when you make a change on one sheets it's made on the whole
group. Highlight a sheet tab then hold down the shift key
and select the last sheet all sheets in between will be
highlighted.
If you need to pick and chose sheets use the control key
instead of the shift key. Don't forget to ungroup the sheets
before you start entering values.
gls858
George Gee - 19 Jul 2007 20:38 GMT
Although Peo's suggestion will copy the formula down column "B", I can't see
how this would be of any use.
Can you give more detail of the data in cols "A" & "B" ?
George Gee
> Great, that seems pretty simple.
>
[quoted text clipped - 14 lines]
>>
>> In cell B2 type "=A2-A1" (without the quotes)
Money 2006 - 20 Jul 2007 20:48 GMT
This if for Fuel Oil Delivery, It's to keep a running total of "Degree Days"
used.
Colum A would have the "Degree day" example 12375, colum B would have to
number of days used since the number above 12345.
12345 00
12375 30
12395 20
That is an example.
> Although Peo's suggestion will copy the formula down column "B", I can't see
> how this would be of any use.
[quoted text clipped - 20 lines]
> >>
> >> In cell B2 type "=A2-A1" (without the quotes)