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.
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.
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.
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
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
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
Hi AlexOram,
You can try to create column headings for your class list by following the below method:
- Click cell A1, and type Last Name.
- Click cell B1, and type First Name.
- 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.
Bookmarks