Results 1 to 8 of 8

Thread: How to auto insert rows in excel

  1. #1
    Join Date
    Jan 2009
    Posts
    41

    How to auto insert rows in excel

    Hi,
    I have excel worksheet on which i need to insert row automatically when inserting data. I have too big data to insert. Is is possible to insert rows automatically?

    Thank you for any advice.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,642

    Re: How to auto insert rows in excel

    There in nothing inbuilt in excel which allows you to automatically add row. You can use external program or software to do so. But using any program or software do adverse effect on spreadsheet. It will not function properly.

  3. #3
    Join Date
    May 2008
    Posts
    4,345

    Re: How to auto insert rows in excel

    You can do it with macros. When you create a macro for the auto insert, go down to as many number of lines you want, and insert the macro again. You can insert macros till the end of the worksheet. Try this macro:
    Sub Insert2Rows()
    Dim c As Long, lrow As Long
    With ActiveSheet
    lrow = .Cells(.Rows.Count, "A").End(xlUp).Row

    For c = lrow - 1 To 1 Step -1
    If .Cells(c, 1).Value <> "" Then
    If .Cells(c, "A").Value <> .Cells(c + 1, "A").Value Then
    .Cells(c + 1, "A").Resize(2).EntireRow.Insert
    End If
    End If

    Next
    End With

    End Sub

  4. #4
    Join Date
    Jan 2008
    Posts
    3,755

    Re: How to auto insert rows in excel

    To insert macro, go to menu Tools->Macro. You can try the following macro:
    Sub InsertRows()
    Dim startRow As Range
    Set startRow = Rows("1001:1001")
    Application.ScreenUpdating = False
    Do Until Application.CountA(startRow) = 0
    startRow.Insert Shift:=xlDown
    Set startRow = startRow.Offset(1000, 0)
    Loop
    End Sub

  5. #5
    Join Date
    Dec 2011
    Posts
    2

    question Re: How to auto insert rows in excel

    Dear friends,

    I am trying to create a master excel file for my school's assessment processes. Each subject has their students list, each list (in each sheet) is linked to a Master List which contains the names of all the students in the school. I did this to help the teachers avoid repeatedly typing the students names.

    I need your kind help with the following:

    If I insert a new student's name in the Master List, the sheets in each of the subject areas should automatically add that student and in that particular row.
    I used the following formula which does not work if I insert a new row:

    C3=IF(Master List!C3="","",Master List!C3)

    I would really appreciate your kind help with this. I guess I would need to use a Macro of which I have no knowledge at all. Please help.

    With thanks,
    Alex Oram

  6. #6
    Join Date
    Dec 2007
    Posts
    2,291

    Re: How to auto insert rows in excel

    Hi AlexOram,

    You can try to create column headings for your class list by following the below method:
    1. Click cell A1, and type Last Name.
    2. Click cell B1, and type First Name.
    3. Continue labeling each column with the type of information you need to add to your class list, such as Address, Phone Number, or E-Mail Address. You can format the text in any cell by clicking the cell and then clicking the format you want on the Formatting toolbar.

  7. #7
    Join Date
    Dec 2011
    Posts
    2

    question Re: How to auto insert rows in excel

    Quote Originally Posted by einstein_007 View Post
    Hi AlexOram,

    You can try to create column headings for your class list by following the below method:
    1. Click cell A1, and type Last Name.
    2. Click cell B1, and type First Name.
    3. Continue labeling each column with the type of information you need to add to your class list, such as Address, Phone Number, or E-Mail Address. You can format the text in any cell by clicking the cell and then clicking the format you want on the Formatting toolbar.
    Thank you EINSTEIN_007 for your reply.

    However, I failed to see how this relates to my problem of creating rows automatically in different sheets which are linked to the Master Sheet.

    My Excel file has one primary list (I call it a Master List) which contains the names of all the students in the school. There are about thirty other sheets within the same file, each corresponding to a particular subject and each has the same list of students.

    The idea is that by modifying the Master List, the lists in the subject sheets should automatically update themselves.

    If add a new raw, the raw should automatically be added to the other sheets in the same location and has the details of what is put in it in the Master List.

    Example: If a Tutor of grade 7S has a new student and she adds it to the Master List, the other subjects should automatically have the newly added student in their lists, that is, a new raw added to their lists with the student's details.

    Is that possible and if yes, how to do that? I would be very grateful for your help.

    With thanks,
    Alexander Oram
    Last edited by AlexOram; 30-12-2011 at 01:31 AM.

  8. #8
    Join Date
    Apr 2012
    Posts
    1

    Re: How to auto insert rows in excel

    Quote Originally Posted by Sam.D View Post
    To insert macro, go to menu Tools->Macro. You can try the following macro:
    Could you send me macro for inserting 1 row each in selection in excel, the selection should be infinite

Similar Threads

  1. How to normalize Excel data in Excel Rows
    By Hache hi in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 07:20 PM
  2. Is it possible to have rows above 65,000 in Excel 2007
    By Nyota in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 06:07 PM
  3. How to Insert Multiple Rows At Once in PHP
    By Zeverto in forum Software Development
    Replies: 3
    Last Post: 22-09-2009, 03:30 PM
  4. Replies: 2
    Last Post: 09-07-2009, 08:57 AM
  5. Auto hide rows and column in Excel 2007
    By Murena in forum Windows Software
    Replies: 3
    Last Post: 28-02-2009, 07:00 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
  •  
Page generated in 1,711,630,249.12542 seconds with 17 queries