Excel formula to change page # when data entered in other page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook that has 4 worksheets. 2 of the worksheets have 3 printable
pages. I am trying to create a formula that will keep a number in the first
three pages, but change the numbers if and when data is entered into a
particular cell of one or all of the 3 pages of another worksheet. example:
Page 1 of 3, Page 2 of 3 and Page 3 of 3 are in one worksheet. The other
worksheet has 3 un-numbered pages. If I enter data in a cell of one of these
pages, I want the first worksheet to show Page 1 of 4, Page 2 of 4 and Page 3
of 4.
 
I probably didn't explain very well. What I need is a formula that says: This
page should be numbered as page 1 of 3 unless there is an entry in cell###,
then it should be numbered page 1 of 4. I just don't know how to say that
with the formula operands.
 
Back
Top