copying formulas

[Mark Goodwin]

this is my formula...

=IF(ISNUMBER('[REWORK 02-05-05.xls]%'!$B$7),'[REWORK
02-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 03-05-05.xls]%'!$B$7),'[REWORK
03-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 04-05-05.xls]%'!$B$7),'[REWORK
04-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 05-05-05.xls]%'!$B$7),'[REWORK
05-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 06-05-05.xls]%'!$B$7),'[REWORK
06-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 07-05-05.xls]%'!$B$7),'[REWORK
07-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 08-05-05.xls]%'!$B$7),'[REWORK
08-05-05.xls]%'!$B$7)


how can i repeat this formula but repalcing '7' with '8','9' and so on with
out having to manually edit it?
Is it also possible to to the same for the dates for the following weeks?
otherwise i have a lot og typing to do! (52 weeks and 365 sheets)

Cheers
Mark

 

[Mangesh Yadav]

I guess you want to make B7 to B8 and B9... as you drag down the formula. If
this is the case, remove the dollar ($) sign before 7 in $B$7. It should be
$B7, and then simply drag or copy down the formula.

- Mangesh

 

[Don S]

this is my formula...

=IF(ISNUMBER('[REWORK 02-05-05.xls]%'!$B$7),'[REWORK
02-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 03-05-05.xls]%'!$B$7),'[REWORK
03-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 04-05-05.xls]%'!$B$7),'[REWORK
04-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 05-05-05.xls]%'!$B$7),'[REWORK
05-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 06-05-05.xls]%'!$B$7),'[REWORK
06-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 07-05-05.xls]%'!$B$7),'[REWORK
07-05-05.xls]%'!$B$7)+IF(ISNUMBER('[REWORK 08-05-05.xls]%'!$B$7),'[REWORK
08-05-05.xls]%'!$B$7)


how can i repeat this formula but repalcing '7' with '8','9' and so on with
out having to manually edit it?
Is it also possible to to the same for the dates for the following weeks?
otherwise i have a lot og typing to do! (52 weeks and 365 sheets)

Cheers
Mark

If you want to replace all of the 7's with 8's in your example, have
you tried Edit/Replace? Be careful that you don't replace unintended
7's (ie: workbook names) by using enough of a text string to be
unique. For example replace !$B$7 with !$B$8

Hope I didn't state the obvious, but sometimes the simplesst solutions
are overlooked.

Don S