+ Reply to Thread
Results 1 to 4 of 4

Insert Rows to Right based on Numeric Figure in Cell

  1. #1
    Registered User
    Join Date
    10-22-2018
    Location
    Turkey
    MS-Off Ver
    Office2010
    Posts
    84

    Question Insert Rows to Right based on Numeric Figure in Cell

    Hi,
    I have rows with headers and filled with values down of each header depending the header contents. Eg: Type, Quantity, Width, Length, Price are the headers in rows C3, D3, E3, F3, G3 & C5, D5, E5, F5, G5... Below of each header (C4, D4, E4, F4, G4 & C6, D6, E6, F6, G6…) the rows can be filled as “Strong”, “1 (dropdown list between 1-15)”, “15,00”, “25,00” & “500,00”, etc. This pattern is used 20 times as one under the other. I need a worksheet change event to insert rows with “Width-Length” to the right based on the value under Quantity header. If 2 is written then must insert two times, if 3 then three times. But must delete the more rows if quantity is altered less than previous figure. You can check my example sheet to see in details.
    Thanks in advance for your kindest prompts.
    Attached Files Attached Files

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Insert Rows to Right based on Numeric Figure in Cell

    Hi zrs,

    Try below code based on your sample file ...
    Please Login or Register  to view this content.
    Last edited by nankw83; 04-21-2021 at 09:24 AM.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  3. #3
    Registered User
    Join Date
    10-22-2018
    Location
    Turkey
    MS-Off Ver
    Office2010
    Posts
    84

    Re: Insert Rows to Right based on Numeric Figure in Cell

    Thanks indeed for your kindest help. It is just what I needed. Wishing healthy days

  4. #4
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Insert Rows to Right based on Numeric Figure in Cell

    Glad to help & thanks for the Rep+

+ 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. insert figure based on cell text on a large table
    By Diogo2 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-07-2020, 04:35 PM
  2. cell is having numeric figure and sentence - Formula Requie
    By ExcelUser2707 in forum Excel General
    Replies: 4
    Last Post: 05-23-2016, 03:00 AM
  3. Insert duplicate rows based on numeric value in column
    By Nu2Excel in forum Excel General
    Replies: 4
    Last Post: 10-11-2015, 03:17 PM
  4. Duplicate rows based on the numeric value of a cell
    By ATMEDIA in forum Excel General
    Replies: 2
    Last Post: 07-10-2014, 12:35 PM
  5. Replies: 4
    Last Post: 02-03-2014, 08:05 AM
  6. [SOLVED] Insert Multiple Rows Based Off Number in Cell and Copy Data From Above New Rows
    By tstell1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2012, 04:15 PM
  7. Insert duplicate rows based on numeric value in column
    By christian13661 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2012, 04:51 PM

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