Auto Generate Worksheet from a List
Closed
Hayley8976
Posts
2
Registration date
Tuesday 15 October 2013
Status
Member
Last seen
16 October 2013
-
15 Oct 2013 à 11:39
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 17 Oct 2013 à 10:45
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 17 Oct 2013 à 10:45
Related:
- Auto Generate Worksheet from a List
- Android auto apk - Download - Other
- Counter strike 1.6 cheats list - Guide
- What is auto download mms - Guide
- Nvidia auto detect - Guide
- Epic games free games list - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
15 Oct 2013 à 11:58
15 Oct 2013 à 11:58
Hi Hayley,
Here you go:
Best reagrds,
Trowa
Here you go:
Sub RunMe()
Dim x, lRow As Integer
x = 5
lRow = Sheets("Basingstoke").Range("A1").End(xlDown).Row
Do
x = x + 1
Sheets("DefectIssueSheet").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = Sheets("Basingstoke").Range("A" & x).Value
Loop Until x = lRow
End Sub
Best reagrds,
Trowa
Hayley8976
Posts
2
Registration date
Tuesday 15 October 2013
Status
Member
Last seen
16 October 2013
16 Oct 2013 à 04:19
16 Oct 2013 à 04:19
Thanks Trowa
I think that I have obviously set my defect issue sheet template up wrong as the new worksheets created for the list are using the first line of information contained in the list.
Is there a way of ensuring that the whole line of infomation is used to input the relevant cells of the template defect issue sheet? For example column A of the "Basingstoke" Sheet should be used to fill cell C3 of the "defectissuesheet", column B of the "Basingstoke" sheet should be used to fill cell L3 of the "DefectIssueSheet", column C of the "Basingstoke" sheet should be used to fill cell C4 of the "DefectIssueSheet" etc
Many Thanks
Hayley
I think that I have obviously set my defect issue sheet template up wrong as the new worksheets created for the list are using the first line of information contained in the list.
Is there a way of ensuring that the whole line of infomation is used to input the relevant cells of the template defect issue sheet? For example column A of the "Basingstoke" Sheet should be used to fill cell C3 of the "defectissuesheet", column B of the "Basingstoke" sheet should be used to fill cell L3 of the "DefectIssueSheet", column C of the "Basingstoke" sheet should be used to fill cell C4 of the "DefectIssueSheet" etc
Many Thanks
Hayley
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
17 Oct 2013 à 10:45
17 Oct 2013 à 10:45
Hi Hayley,
Don't know what comes after "etc" but the following code covered the 3 cell locations:
Best regards,
Trowa
Don't know what comes after "etc" but the following code covered the 3 cell locations:
Sub RunMe()
Dim x, lRow As Integer
x = 5
lRow = Sheets("Basingstoke").Range("A1").End(xlDown).Row
Do
x = x + 1
Sheets("DefectIssueSheet").Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = Sheets("Basingstoke").Range("A" & x).Value
ActiveSheet.Range("C3").Value = Sheets("Basingstoke").Range("A" & x).Value
ActiveSheet.Range("L3").Value = Sheets("Basingstoke").Range("B" & x).Value
ActiveSheet.Range("C4").Value = Sheets("Basingstoke").Range("C" & x).Value
Loop Until x = lRow
End Sub
Best regards,
Trowa
