Copying DSUM formulas with absolute references
 

=DSUM('Bill Log 2007-2008'!$A:$O,"Amount",'Bill Crit-FHC'!$AB$15:$AD$16)
I have inserted two colums in between the next working column so the pasted
formula should read: =DSUM('Bill Log 2007-2008'!$A:$O,"Amount",'Bill
Crit-FHC'!$AE$15:$AG$16)
and so on...does this make sense? I've tried over and over again choosing
different options, formatting only, formulas and formatting. I am about to
go batty. Thanks :-)