Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 26-05-2009
Member
 
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.
Reply With Quote
  #2  
Old 26-05-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
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.
Reply With Quote
  #3  
Old 26-05-2009
Member
 
Join Date: May 2008
Posts: 4,339
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:
Quote:
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
Reply With Quote
  #4  
Old 26-05-2009
Member
 
Join Date: Jan 2008
Posts: 3,751
Re: How to auto insert rows in excel

To insert macro, go to menu Tools->Macro. You can try the following macro:
Quote:
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
Reply With Quote
  #5  
Old 29-12-2011
Member
 
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
Reply With Quote
  #6  
Old 30-12-2011
Member
 
Join Date: Dec 2007
Posts: 2,273
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.
Reply With Quote
  #7  
Old 30-12-2011
Member
 
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.
Reply With Quote
  #8  
Old 19-04-2012
Member
 
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
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to auto insert rows in excel"
Thread Thread Starter Forum Replies Last Post
How to normalize Excel data in Excel Rows Hache hi MS Office Support 2 24-02-2012 07:20 PM
Is it possible to have rows above 65,000 in Excel 2007 Nyota MS Office Support 2 21-02-2012 06:07 PM
How to Insert Multiple Rows At Once in PHP Zeverto Software Development 3 22-09-2009 03:30 PM
Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003 awkwardsmile Software Development 2 09-07-2009 08:57 AM
Auto hide rows and column in Excel 2007 Murena Windows Software 3 28-02-2009 07:00 PM


All times are GMT +5.5. The time now is 03:33 AM.