+ Reply to Thread
Results 1 to 8 of 8

Using Autofill to autopopulate columns

Hybrid View

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    Upper Lower Middleton
    MS-Off Ver
    Excel 2007
    Posts
    7

    Using Autofill to autopopulate columns

    I have four items in column "U" starting in row 6
    Screwdriver
    Hammer
    Prybar
    Wrench
    Extension

    In column "V" I have the amount for each of the items. (these values would be user input)

    Here is the data
    U V
    Screwdriver 3
    Hammer 4
    Prybar 2
    Wrench 3
    Extension 2

    Desired output would be:
    Screwdriver
    Screwdriver
    Screwdriver
    Hammer
    Hammer
    Hammer
    Hammer
    Prybar
    Prybar
    Wrench
    Wrench
    Wrench
    Extension
    Extension

    I would like each item in column "U" to repeat in column "B" the number of times the user entered in column "V" Can anyone help?

    Thanks

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Using Autofill to autopopulate columns

    It's a bit long winded but if you are starting in row 1 of column B:
    =IF(ROW()<=V$6,U$6,IF(ROW()<=V$6+V$7,U$7,IF(ROW()<=V$6+V$7+V$8,U$8,IF(ROW()<=V$6+V$7+V$8+V$9,U$9,IF(ROW()<=V$6+V$7+V$8+V$9+V$10,U$10,"")))))
    Last edited by ragulduy; 05-29-2013 at 11:35 AM.

  3. #3
    Registered User
    Join Date
    05-29-2013
    Location
    Upper Lower Middleton
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Using Autofill to autopopulate columns

    That's brilliant thank you. How can I adjust your response starting in row 6 of column B. There's a bit of headers and what not stopping me from starting in row 1. Thanks again.

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Using Autofill to autopopulate columns

    Replace row() with row()-5

  5. #5
    Registered User
    Join Date
    05-29-2013
    Location
    Upper Lower Middleton
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Using Autofill to autopopulate columns

    That did the trick. Perfect !!! Thank you so much. I do appreciate your help

  6. #6
    Registered User
    Join Date
    05-29-2013
    Location
    Upper Lower Middleton
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Using Autofill to autopopulate columns

    One more question regarding your solution if I may, how do I get the rows created to push down the total row at the bottom. You solution works brilliantly but I'm losing the last few rows if one item occurs too many times. Thanks again.

  7. #7
    Registered User
    Join Date
    05-29-2013
    Location
    Upper Lower Middleton
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Using Autofill to autopopulate columns

    <<<<<<<<<<<<<<<<<<<<<<<post deleted>>>>>>>>>>>>>>>>>>>>>>>>
    Last edited by TheTrooper; 05-29-2013 at 03:19 PM. Reason: Posted in error

  8. #8
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Using Autofill to autopopulate columns

    Can you upload a workbook with an example of your data? I'm not sure I follow what you mean (click on go advanced when replying and then attachments to upload a workbook). If you are talking about inserting the cells into column B and shifting everything else down you will need a vba macro for that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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