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
--
Total Office Novice

[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



"Mark Goodwin" <[email protected].(spamfree)> wrote in message
news:[email protected]...
> 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
> --
> Total Office Novice

[Don S]

On Tue, 10 May 2005 18:35:04 -0700, Mark Goodwin
<[email protected].(spamfree)> wrote:

>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