How to create a new sheet based on student Id numbers
Closed
bookman35
Posts
1
Registration date
Monday April 19, 2021
Status
Member
Last seen
April 19, 2021
-
Apr 19, 2021 at 01:15 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Apr 23, 2021 at 09:28 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Apr 23, 2021 at 09:28 AM
Related:
- Example of student number
- Office home and student 2019 download - Download - Office suites
- Office home and student 2010 download - Download - Office suites
- Download office 2013 home and student - Download - Office suites
- Cisco packet tracer student download - Download - Other
- Student marksheet in excel - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Apr 22, 2021 at 11:39 AM
Apr 22, 2021 at 11:39 AM
Hi Bookman,
I don't see any names in your screenshot. I also don't know how your sheet is called. So for the code below to work I made the following assumptions:
To change the sheet name in the code to match your, you can do so on code line 4.
To change the column letter where the names are located, you can do so on code line 7.
Best regards,
Trowa
I don't see any names in your screenshot. I also don't know how your sheet is called. So for the code below to work I made the following assumptions:
- The sheet with all the data is called Sheet1.
- The column on Sheet1 with all the names is column B.
Sub RunMe()
Dim Header1 As Variant
Sheets("Sheet1").Select
Header1 = Range("A1:J1")
For Each cell In Range("B2:B" & Range("B1").End(xlDown).Row)
cell.EntireRow.Copy
If Not SheetExists(cell.Value) Then
Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Name = cell.Value
Range("A1:J1").Value = Header1
Else
Sheets(cell.Value).Select
End If
Range("A" & Range("A" & Rows.Count).End(xlUp).Row).Offset(1, 0).PasteSpecial
Next cell
End Sub
Function SheetExists(SheetName As String) As Boolean
SheetExists = False
On Error GoTo NoSuchSheet
If Len(Sheets(SheetName).Name) > 0 Then
SheetExists = True
Exit Function
End If
NoSuchSheet:
End Function
To change the sheet name in the code to match your, you can do so on code line 4.
To change the column letter where the names are located, you can do so on code line 7.
Best regards,
Trowa
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Apr 23, 2021 at 09:28 AM
Apr 23, 2021 at 09:28 AM
Hello Bookman,
If you supply a sample of your actual workbook, it will make solving this for you much, much simpler.
Please upload a sample of your workbook to a free file sharing site such as WeTransfer or Drop Box then post the link to your file back here. Make sure that the sample is an exact replica of your workbook and use dummy data for names or any other more sensitive data.
TrowaD (and any other helpers who may drop in) will be very happy to have something to work/test with.
Thank you Bookman.
Cheerio,
vcoolio.
If you supply a sample of your actual workbook, it will make solving this for you much, much simpler.
Please upload a sample of your workbook to a free file sharing site such as WeTransfer or Drop Box then post the link to your file back here. Make sure that the sample is an exact replica of your workbook and use dummy data for names or any other more sensitive data.
TrowaD (and any other helpers who may drop in) will be very happy to have something to work/test with.
Thank you Bookman.
Cheerio,
vcoolio.