Hi Softrak,

Adjusting the row heights did the trick - thanks.

Regarding the "floating" Bank row, I do not understand why you thought/think that "it doesn't matter what any of the other column values are" and the sample spec noted does not use multiple columns so the formulas there weren't much help in that regard.

OK so here's the scenario:

> Col.D Current period is June 2007, Balance is CR $1,000
> Col.E Budget Current Period June 2007, Bal is DR $ 900
> Col.G Prior Year, June 2006 the balance was DR $ 700

Acknowledging that Budget is an unusual column on a Balance sheet, my feeling is that
> all 3 columns of the Bank should only show in one section (row)
> and that section should be in the Current Liabilities
> I also believe that the spec. should be able to handle any
combination of the above, continuing to show the single Bank
row in the section that corresponds to the Current Period
Balance
> Whichever section the Bank Row appears in, then it should
be "hidden" in the other section.
> And yes, the figures must add up and not be duplicated :-)

I tried accomplishing this using the formulas you noted from the sample spec above and bearing in mind that you said the "other" column values did not matter - I just could not get it to work.

So I went back to my method:

Liabilities Section:
Col.D: =ADCRONLY("GLDATA.BAL",$B40)
Col.E: =IF($D40==0,0,-ADGET("GLDATA.BM",$B40))
Col.G: =IF($D40==0,0,-ADGET("GLDATA.BAL_PY",$B40))
Col.I: =IF($D40==0,IF($E40==0,IF($G40==0,"FormatHidden",""),""),"")

Asset section similar but with =ADDEBIT and the embedded =ADGET commands would not have the "-" sign in front.

Seems to work, the only drawback being that it would appear that one looses the "Drill Down" ability if the AD??? function is embedded within other functions.

If there's a way to accomplish this and still get full drill down capability, please let me know.

Thanks for bearing with all that and I hope that someone will find it useful - Peter