I have a multi-tabed Excel Spreadsheet Report. Each Page contains a Page Number in the following format:
- 12 -
The reports begin with Tab2. The first page of Tab2 reports (generally two pages long) gets it page number from a user supplied entry on Tab1.
If the user supplied value in cell D53 of Tab1 contains the number 3, this formula, in B69 of Tab2
="- "&(Tab1!$D$53)&" -"
Yields the following results:
- 3 -
If want cell B144 of Tab2 to increment this number by 1.
If the Tab2 report is three pages long, there could be a value in B217! If so, I would want the resulting value in B217 incremented by 1.
I cannot do this with VBA. That is beyond my expertise.