Excel formula for logbook

In article m,
Wizard of Draws wrote:
I also wanted to comment that, for my version of Excel at least, it was
required for me to rename the cell that contained the cutoff formula. For
some reason, just referencing the default cell name made the formula not
work.

When you copy formula cells in Excel the default is to treat the other
cells referenced as relative, so that if you make 'B1' reference 'A1'
and then copy it to 'B2' it will reference 'A2'. To stop that you can
either name the cell or use $A$1 (the $ for each of the row and column
nails them down).

I suggested renaming because it even works across sheets (in case you
wanted the summary on a separate sheet) and the syntax for referring
to values in other sheets is ugly.

--
Ben Jackson

http://www.ben.com/

On 8/29/04 4:49 AM, in article nMgYc.201395$8_6.135186@attbi_s04, "Ben
Jackson" wrote:

In article m,
Wizard of Draws wrote:
I also wanted to comment that, for my version of Excel at least, it was
required for me to rename the cell that contained the cutoff formula. For
some reason, just referencing the default cell name made the formula not
work.

When you copy formula cells in Excel the default is to treat the other
cells referenced as relative, so that if you make 'B1' reference 'A1'
and then copy it to 'B2' it will reference 'A2'. To stop that you can
either name the cell or use $A$1 (the $ for each of the row and column
nails them down).

Actually, I forgot I knew this from working with a freebie spreadsheet long
ago. But I'm not sure it had a rename function.


I suggested renaming because it even works across sheets (in case you
wanted the summary on a separate sheet) and the syntax for referring
to values in other sheets is ugly.

Elegant is always preferable.
I like the hide column feature too. Thanks.
--
Jeff 'The Wizard of Draws' Bucchino
Cartoons with a Touch of Magic�
http://www.wizardofdraws.com
http://www.cartoonclipart.com