copying absolute references

[Dave W]

how can I copy the following formula down without having
to change each indiviual sheet reference. I've tried using
indirect in the formula, but I'm not having any luck. I
have researched various sites and I can't seem to find
anything that will make sense to me.

=IF($A$10<>"",SUMIF('Base Bid Item (1) '!
$B$11:$B$110,">L.10*",'Base Bid Item (1) '!G$11:G$110)-
SUMIF('Base Bid Item (1) '!$B$11:$B$110,"=M.11*",'Base
Bid Item (1) '!G$11:G$110),"")

Can any one help?

 

[Frank Kabel]

Hi
how should your sheet names change?. Is there a naming logic for them?.
e.g. if they are named like
'Base Bid Item (#number)

then try the following formula
=IF($A$10<>"",SUMIF(INDIRECT("'Base Bid Item (" & ROW(1:1) & ") '!
$B$11:$B$110"),">L.10*",INDIRECT("'Base Bid Item (" & ROW(1:1) & ")
'!G$11:G$110"))-
SUMIF(INDIRECT("Item (" & ROW(1:1) & ")
'!$B$11:$B$110"),"=M.11*",INDIRECT("'Base
Bid Item (" & ROW(1:1) & ") '!G$11:G$110")),"")

 

[Dave W]

Thank you Frank
You assumed correctly regarding the sheet naming
I have been pulling my hair out trying to get
the "indirect" approach to work.