+ Reply to Thread
Results 1 to 2 of 2

VBA to fill in blank column with text based on cell value

  1. #1
    Registered User
    Join Date
    06-05-2019
    Location
    Maryland
    MS-Off Ver
    i have no idea
    Posts
    5

    VBA to fill in blank column with text based on cell value

    stair report pic.PNG

    I have quantities listed in column D. In my worksheet, the quantities can go as high as like 16 I believe. I need a macro that will recognize the quantity and add quantity - 1 rows above or below, with the same data. For example, if the quantity is 4, it will add three additional rows, and add in the same data in all of those additional rows. After that, for all quantities, I need "1 of 2" "2 of 2" etc.... (based on the quantity) to populate in to the last blank column (column K). So if a quantity is 4, the original row, as well as the 3 added rows, should all have the same data, and column K will say 1 of 4, 2 of 4, 3 of 4, 4 of 4, consecutively in column K. It would help if a blank row remained in between each row, but it is not 100% necessary. I have made a similar post on reddit but it will not allow me to link to the post because I am too new to post links?

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: VBA to fill in blank column with text based on cell value

    As you have five posts, I believe that you should be able to post a link to the reddit thread. If you received a solution from reddit then please mark this thread as 'Solved'. If your query has not been answered elsewhere then it may help us to help you if you could upload the workbook from which the screen shot is produced. Be sure to include some manually produced results so that we will have something against which to test our formulas/code.
    To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. If any cell in column contains value then fill blank cells in column with !
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2016, 02:14 PM
  2. [SOLVED] Toggle fill Color in cell based on condition of cell--blank or text added.
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2014, 08:39 PM
  3. [SOLVED] Macro to fill blank cells in column A based on non-blank cells
    By ktalamantez in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2014, 02:47 PM
  4. [SOLVED] Fill a cell in Column B based on the text in Column A using a table on sheet 2
    By lbrasfie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-25-2013, 01:56 PM
  5. Fill cell in column only if blank.
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2013, 08:55 AM
  6. Find Blank cell in column then Fill Up
    By klassic in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2012, 02:39 AM
  7. fill text in the blank column
    By ronlau123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2011, 10:08 AM

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