Thanks:  0
Likes:  0

1. Many thanks to those who can help this one!

Suppose
cell D2 contains formula '=Guardian!B59'
cell B8 contains formula '=Guardian!B59'
cell B21 contains formula '=Wealth!B59'
cell B35 contains formula '=Growth!B59'

Each day I have to go into these formula and Add 1 to them so that thay become

cell D2 contains formula '=Guardian!B60'
cell B8 contains formula '=Guardian!B60'
cell B21 contains formula '=Wealth!B60'
cell B35 contains formula '=Growth!B60'

The following day B61 so on so on..
Is there a quicker way to do so?

2. Just select the range and use Edit>Replace

B59 with B60

3. You should set a cell value (in my function it is A1) as the starting date of this process.

I set A1 = 03/26/2002 (as starting date)

Then i used this formulas:

D2 --> =INDIRECT("Guardian!B"&(59+DAYS360(A1,NOW())))
B8 --> =INDIRECT("Guardian!B" & (59+DAYS360(A1,NOW())))
B21--> =INDIRECT("Wealth!B"& (59+DAYS360(A1,NOW())))
B35--> =INDIRECT("Growth!B"& (59+DAYS360(A1,NOW())))

I hope this is what you need.

(Edited because function parameter seperator in my Excel Version)
_________________
Oz ~ TheWordExpert

[ This Message was edited by: smozgur on 2002-03-26 02:02 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•