Macro Codes... I have no idea what I'm doing.

[helpme05]

I am working on a workbook, and I know I need a code. I have never used one and I am clueless. I'm hoping someone can help me!!! I know you have helped others. I want to take the information from one workbook and split it into 2 others depending on one column's information. The "master list" has A1-U466, and grows daily. I need all the information in each row to copy over to another workbook based off the information in column C. The information in column C is either "SA" or "CDF". These will have their own Sheets, labeled as such. I'm working with Excel 2010. Please help me, I am at a loss on how to get this done. Thank you in advance!!!!!!

 

[L. Howard]

Try this, copy and paste into the "master list" vb editor. Assign to a button or alt+ F8 and select Sub SA_CDF() then click Run.

Option Explicit

Sub SA_CDF()
Dim i As Range
For Each i In Range("C1:C20")
  If i.Value = "SA" Then i.Offset(0, -2).Resize(1, 21).Copy _
    Destination:=Sheets("SA").Range("A" & Rows.Count).End(xlUp).Offset(1)
  If i.Value = "CDF" Then i.Offset(0, -2).Resize(1, 21).Copy _
    Destination:=Sheets("CDF").Range("A" & Rows.Count).End(xlUp).Offset(1)
Next
End Sub

Regards,
Howard

 

[L. Howard]

Whoops, better change this line

For Each i In Range("C1:C20")

to

For Each i In Range("C1:C466")

Howard