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.