We help IT Professionals succeed at work.
Get Started

EXCEL SPREADSHEET FORMULA - PART DUEX!

161 Views
Last Modified: 2015-03-23
If 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.
PART TWO OF THE QUESTION...
Subsequently, reports under Tab3 or generally 2, 3 or 4 pages long.  
I want cell B69 of Tab3 to test for a value in Tab2, cell B17.  If there is a value there, increment by 1.
If not value in cell B217 of Tab2, Test, then increment the value of cell B144 of Tab2 by one and show that value in B68 of Tab3.  If there is no value in B144 of Tab2, then increment the value which appears in B69 of Tab2.
NOTE: There will always be at least on page under Tabs 2, 3 and 4 and that page number always appears in B69 in the respective Tabs.
I cannot do this with VBA.  That is beyond my expertise.
Comment
Watch Question
IT Manager
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE