routine Formula editing

chaju · Mar 26th, 2002, 02:49 AM

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?

Dave Hawley · Mar 26th, 2002, 02:51 AM

Just select the range and use Edit>Replace

B59 with B60

smozgur · Mar 26th, 2002, 03:01 AM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 02:49 AM	#1
chaju Board Regular Join Date: Mar 2002 Posts: 82	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?

Mar 26th, 2002, 02:51 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Just select the range and use Edit>Replace B59 with B60

Mar 26th, 2002, 03:01 AM	#3
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	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 ]