F
Francis Hookam
Variable in footer
I have =COUNTA(Bx:Bxx) in the spreadsheet in, let us say, A1 - it varies as
the number of rows change - I am counting surnames of members of a club in
this case (it does not matter if the same total appears on more than one
page)
Can the value in A1 (or any cell) be displayed in the footer so that at each
printing it is updated according to the state of the worksheet at the time?
Francis Hookham
I have =COUNTA(Bx:Bxx) in the spreadsheet in, let us say, A1 - it varies as
the number of rows change - I am counting surnames of members of a club in
this case (it does not matter if the same total appears on more than one
page)
Can the value in A1 (or any cell) be displayed in the footer so that at each
printing it is updated according to the state of the worksheet at the time?
Francis Hookham