+ Reply to Thread
Results 1 to 7 of 7

Populating items from given value

  1. #1
    Forum Contributor
    Join Date
    12-02-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    112

    Question Populating items from given value

    Hi,

    There are two groups of data:

    Group1:

    Please Login or Register  to view this content.
    Group2:

    Please Login or Register  to view this content.
    Where the value of H1 is 4 which changes from time to time.

    The desired solution is to populate the above groups according to the value at H1.

    As there is 4 at H1 on this occasion the values of Group 1 and Group 2 should be newly populated only until 4th row & the values at other rows should be zero, For example:

    NEW Group 1:

    Please Login or Register  to view this content.
    NEW Group 2:

    Please Login or Register  to view this content.
    For the convenience of respective contributors an workbook with datas is also provided to ease the explanation.
    Thank you
    Attached Files Attached Files
    Last edited by LAVA2; 08-17-2018 at 05:34 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Populating items from given value

    "As there is 4 at H1 on this occasion the values of Group 1 and Group 2 should be newly populated only until 4th column & the values at other columns should be zero, For example:"

    ROWS not columns, columns go up and down like the architectural column of a building, rows go horizontally.
    You#'re filling in data up to the 4th ROW not 4th column, the 4th column is column D.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    12-02-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    112

    Re: Populating items from given value

    Special-K do you know how to proceed towards solution, cheers for that advice about rows

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Populating items from given value

    Cells can contain a formula or a number, not both.
    You have numbers in row 5 onwards. If they have been set by a formula you just need to adjust the formula. IF(AND(ROW(A5)>H1,H1<>0),0,get number from somewhere)
    But if they are manually typed in, not based on a formula, then the only way to do this is via VBA, of which I'm not an expert.

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Populating items from given value

    With helper column you can do. Insert in "A" column with =row() formula copy down.
    In "J1"
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copy paste across.
    See attach file.
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  6. #6
    Forum Contributor
    Join Date
    12-02-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    112

    Re: Populating items from given value

    Thanks a lot avk for providing such a beautiful method

  7. #7
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Populating items from given value

    Hi

    Try This in I1 and copy across

    =IF($H$1>=ROWS($A$1:$A1),A1,0)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Populating Vouchers With Purchased Items For Auction
    By ElectroPulse in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-27-2015, 11:55 PM
  2. populating a list of items depending upon whether cells have values
    By jase366 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-03-2013, 02:18 AM
  3. Replies: 2
    Last Post: 04-29-2013, 05:18 PM
  4. Populating a list box with items from cell
    By HikariHitachi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2013, 04:13 PM
  5. [SOLVED] Populating an array with selected ListBox items
    By wz4np1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2012, 07:52 AM
  6. Populating Treeviws Child Items
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2010, 12:40 PM
  7. Problem: populating listbox items
    By ilyaskazi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2005, 07:22 AM

Tags for this Thread

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