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.

It is best to introduce a hard break in the print setup and then use the
print header, but you can determine on what page a cel is located:

http://groups.google.com/group/micro...3252502ce2ac30


--
Gary''s Student
gsnu200709


"Solograndma" wrote:

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.

"Gary''s Student" wrote:

It is best to introduce a hard break in the print setup and then use the
print header, but you can determine on what page a cel is located:

http://groups.google.com/group/micro...3252502ce2ac30


--
Gary''s Student
gsnu200709


"Solograndma" wrote:

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.