+ Reply to Thread
Results 1 to 3 of 3

Entering changing formulas in every other cell

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    kranj, slovenia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Entering changing formulas in every other cell

    Hello
    My first post and i also have to say i am a beginner at writing macros.

    I have a problem and i would ask for advice. I would like to write a macro for excel that enters formulas as follows. First i would like to divide cells with each other in this order C3/D3, C3/E3,C3/F3, C3/G3 etc. if there is no value in next cell it goes to divide D3/E3, D3/F3, D3/G3 etc if there is no value in the next cell it goes to divide E3/F3, E3/G3 and so forth until no value is left to divide.
    Each division or formula is entered in the target cells in this sequence: T3, AN3, BH3 etc. So first target cell is T3 and next one is always every 20th cell. So first formula which divides C3/D3 is entered in T3, second C3/E3 is entered in AN3 and so forth.

    For now i have 16 cells filled with values from C3 to R3 and i had to write 120 sentences in vba to solve this but problem becomes huge when i will be adding another cells filled with value.


    tnx

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: Entering changing formulas in every other cell

    Cross-post http://www.ozgrid.com/forum/showthread.php?t=176794

  3. #3
    Registered User
    Join Date
    03-27-2013
    Location
    kranj, slovenia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Entering changing formulas in every other cell

    Quote Originally Posted by StephenR View Post
    My apologies it won t happen again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1