Fill in cells with an array

Discussion in 'Microsoft Excel Misc' started by dgh, May 15, 2009.

  1. dgh

    dgh Guest

    I have a row of numbers that I want to fill into a row only if a variable
    cell increments by 1. For instance:

    Array = 200 10 5 6 8

    Variables 0 1 1 2 2 3

    Row 1 200 10 5 6 8
    Row 2 200 10 5 6 8
    Row 3 200 10 5 6 8



    I want to be able to change the variables so the array can stat at different
    cells within the row.


    --
    dgh
     
    dgh, May 15, 2009
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. shadestreet
    Replies:
    2
    Views:
    201
    BrianB
    Jun 21, 2004
  2. Matt Stephans
    Replies:
    3
    Views:
    519
  3. Guest

    Fill cells from non-adjacent cells

    Guest, Mar 25, 2005, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    304
    Guest
    Mar 25, 2005
  4. Guest

    create a fill in template to tab to fill in cells

    Guest, Jul 6, 2005, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    274
  5. Guest
    Replies:
    2
    Views:
    269
  6. Guest

    fill cells with a value from two previous cells

    Guest, Jan 3, 2006, in forum: Microsoft Excel Misc
    Replies:
    4
    Views:
    156
    Guest
    Jan 3, 2006
  7. Replies:
    3
    Views:
    626
    Guest
    Sep 11, 2006
  8. dgh

    Fill in cells with an array

    dgh, May 15, 2009, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    109
Loading...