Auto Generate Worksheet from a List
Closed
Hayley8976
Posts
2
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
October 16, 2013
-
Oct 15, 2013 at 11:39 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 17, 2013 at 10:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 17, 2013 at 10:45 AM
Related:
- Auto Generate Worksheet from a List
- My contacts list names - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Grand theft auto 1 download - Download - Action and adventure
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Facebook auto refresh - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 15, 2013 at 11:58 AM
Oct 15, 2013 at 11:58 AM
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 October 15, 2013
Status
Member
Last seen
October 16, 2013
Oct 16, 2013 at 04:19 AM
Oct 16, 2013 at 04:19 AM
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 September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 17, 2013 at 10:45 AM
Oct 17, 2013 at 10:45 AM
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
