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:
- Student id number example
- Office home and student 2019 download - Download - Office suites
- Student marksheet in excel - Guide
- Office home and student 2010 - Download - Office suites
- Student position formula in excel - Excel Forum
- Autocad 2024 student version - Download - CAD
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
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.