[SIZE=14px]I posted this to [FONT="Calibri"]AliGW earlier but I think I posted wrong. Can anyone help me?[/FONT]
I'm not necessarily new to this site but never figured out how to really use it so I'm just taking a shot at getting some help.
I have a list in excel that consist of several columns. What I have to do with this list is fill a sheet with each line item. I've gotten this much to work so far:
[VBA]Sub CreateSheetsFromAList()
Dim MyCell As Range, MyRange As Range, wbBook As Workbook
'THIS IS MY PROBLEM HERE
Set MyRange = Sheets("WS_Items").Range("A3")
Set MyRange = Range(MyRange, MyRange.End(xlDown))
Set MyRangeA = Sheets("WS_Items").Range("B3")
Set MyRangeA = Range(MyRangeA, MyRangeA.End(xlDown))
For Each MyCell In MyRange
ShowSheets
Worksheets("Template_WBS").Visible = True
Sheets("Template_WBS").Select
Sheets("Template_WBS").Copy before:=Sheets("Rates")
Worksheets("Template_WBS").Visible = False
Sheets("Template_WBS (2)").Select
Sheets("Template_WBS (2)").Name = MyCell
' Sheets(MyCell).Activate
'Proposal Number
Range("E8").Value = Sheets("PROJECT_INFORMATION").Range("A2")
Range("G8").Value = "11/01/2018"
Range("N8").Value = MyCell
Range("N8").Select
'Prepared by
Range("I8").Value = Sheets("PROJECT_INFORMATION").Range("D2")
Range("G8").Value = "11/01/2018"
Hidetemplates2
HideSheets
'Sheets("Template_WBS").Add After:=Sheets(Sheets.Count) 'creates a new worksheet
'Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
Next MyCell
End Sub[/VBA]
But my problem is that this is only the first column that I manage to fill the sheet once the sheet is inserted into the table. How do I get the other columns to fill in the sheets as they insert into the table. I have about 4 other columns to include in this process.
I have included an attachment to give you an idea of what I'm looking for. This is just a small portion of what I need to do. It's actually 384 items and more columns. I just need someone to get me started or an idea of how I do this.
I pray you can help me or at least get me started. On a scale of 1-10 I'm about a 8 in understanding VBA. I've wrote several programs for the company I work for with the help of others. Thank you in advance for your help.[/SIZE]