|Thank you for being patient... |
What I am trying to do is this.
The program calculates 4 different cost/savings analysis. It also allows for inputting 4 separate plans- so a company could have up to 4 plans.
Each input screen. Generates 2 sheets for each analysis and a summary sheet.
If data is not entered for a specific analysis then the sheet containing that report will be blank, that is why I want the print macro to check if there is data in the cell (j35) in the first of the 2 sheets so that it only print the necessary pages pus the summary page.
I am thinking to set up 4 separate print buttons each or a specific analysis, that way an agent can print whatever he/she needs based on the original input, reason being is that if the agent did not input specific data for a break even analysis then he/she would not be printing this reports.
I would have one macro to print a standard savings analysis.
So the logic is this: Standard savings analysis- sheets with yellow tabs
Input screen 1 = populates “Sav. Proposal 1” & “EE-ER by class propsl 1 plan 1”
Input screen 2 = populates “Sav.proposal2” & “EE-ER by class propsl2”
Input screen 3= populates “ Sav.proposal3” & “EE-ER by class proposl3”
Input screen 4= populates “ Sav.proposal4” & “EE-ER by class propsl4”
And the totals from the above sheets populates the “standard saving summary.”
So I want to print the saving summary when cell (j35) of the “ Sav.proposal 1” is >1
I can then create another macro for a custom analysis. And repeat the process by changing the names of the sheets that will be printed.
All of the report sheets are hidden so the macro will need to unhide them, check for the cell value, print or skip then hide the sheet again.
again template 1 will produce 2 sheets that i want to print out only if the cell value of (j35) in (sheet1) is >1 please note that cell (j35) contains a formula so it is not blank that is why i want to chech that the value is greater then 1.
if the value is >n 1 then sheei1 & 2 are printed otherwise no, then i want the program to look at sheet 3&4 and apply the same logic. at the end i want the program to look at sheet1 again and if the value of cell (j35) is > 1 print "summary sheet"
the cell j35 in each sheet is a total so i am thinking that if J35 has a value greater then 1 then the actual sheet contains data that is printable and therefore both sheets need to b printed.