routine Formula editing
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: routine Formula editing

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just select the range and use Edit>Replace

    B59 with B60



  3. #3
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    799
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com