+ Reply to Thread
Results 1 to 5 of 5

how to insert row based on the value from cells

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    baia mare
    MS-Off Ver
    Excel 2003
    Posts
    13

    how to insert row based on the value from cells

    Hi

    How can i insert the number of rows under each cell that contains the number of rows to be added?

    for example

    in C3 i selected number 4 so it will insert 3 rows under that cell, and if possible the row inserted have unable possibility to enter datas only in column J K L M.

    in case after some time i will change the value from c3 with 2 than will delete the last 2 rows.

    this condition id like to have it at all cels from colomn C
    If the cell is emty it wont do nothing, same in case is selected nr1.
    i won't have other number only 1 2 3 4 5
    if possible to make the inserted rows to look like the pictures attached.

    Thank you
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: how to insert row based on the value from cells

    Why do you want to convert a "proper data set" into something that is not a "proper data set"? Doing so will only make the manipulation of your data much more difficult. Doing what you want will prevent proper sorting, make data extraction difficult and serves no purpose other than visual.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    02-11-2014
    Location
    baia mare
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: how to insert row based on the value from cells

    I want to make this as simple as possible for the operator of this data base, which knows only to make summ and small things like this. the program will be also protected so nobody can delete by mistake the formulas.

    i don't know the programing language, but the code should be something like this;

    it will count the colounm I and where it's something diferent then blank space or 1, it should unprotect the sheet insert number of rows, block the parts of cells that i want ( ore introduce blank space ) then, reprotect the sheet and go futher.

    It's not only for visual, it for tacking out human mistakes.

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: how to insert row based on the value from cells

    Proper data sets are not for visual appeal. That can be done in reports. I can't see how inserting blank rows has any benefit for eliminating human mistakes.

    Good luck.

  5. #5
    Registered User
    Join Date
    02-11-2014
    Location
    baia mare
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: how to insert row based on the value from cells

    The Sheet is designed for a concrete backing plant. for example if i make 9 mc of concrete there are cases in which i poor that concrete in 2 3 diferent forms (precast) for diferent clients, so the coloum J K L should be different because are different client, that's why i have to insert rows.

    thank you

+ 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. [SOLVED] Insert Rows based upon value in cells
    By forknowledge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2014, 06:12 AM
  2. Insert column based upon two cells
    By lawboy1976 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2012, 05:37 AM
  3. Excel 2007 : Insert a column based on a cells value
    By grsnipe in forum Excel General
    Replies: 1
    Last Post: 09-22-2011, 01:27 PM
  4. Insert cells based on test
    By jdh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2007, 07:58 PM
  5. Insert a value based on another cells value
    By paulcraigdainty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2007, 07:11 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