Need help with a formula in the design of a two page invoice form

Hi,

I'm new to the forum and hope someone can help. Please reference the attached spread sheet. I’m trying to design a two page invoice in excel 2007 for when the second page is required due to running out of lines in either the repair or the parts section of the form. What I what to happen is once an entry is made in either cell J10 of the repair section or cell H28 of the parts section on the second page, cell J45 (Total) on the first page becomes blank, so the total only shows in cell J45 of the second page. The subtotal (J43) on page 1 should continue to show the total for that page and naturally, if a second page is not required, the total should show in cell J45 on the first page. In that case it doesn’t matter if it show on page 2 because it won’t be printed.

The formula I’ve used in cell J45 on page 1 is below, but it is not working as I intended. I need it to show the total until I go to the second page and then it should go blank. Any help would be greatly appreciated.

=IF(ISBLANK('Page 2 0f 2'!H28),(J43)," ")

Thanks,

Jerry