Named Ranges in Formulas

R

Rich Mogy

I have a worksheet with four columns -

Total Hours
Percent to total Hours
Value of Hours
Percent to total Value of Hours

The row with the total varies, so in my macro I have named the row with the
total TOT_HOURS (=a and whatever the last row is)

In column B, on each row, I perform the calc b1/tot_hours, etc., to get the
percent to total.

How could I make tot_hours relational, that is, when I copy the formula to
column d, have tot_hours refer to column c instead of column a?

Just copying the formulas doesn't work.
 
B

Bob Phillips

define the range with relative columns, e.g.

=A$1:A$100

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top