Hi,

I wrote the code below I read from a book to pull data from a tab
("Prioritization Brk Out") to update another tab w/in the same spreadsheet.

However, I now need to have the code to look @ "Prioritization Brk Out" tab
and now only pull only the rows of data if that particular row has the value
"Commercial" in it.

I have reached the end of my VBA skills and am asking for this fine
communities help.

Mike

------------

Private Sub CommandButton1_Click()

Application.ScreenUpdating = False


Range("A7:A100").Value = Sheets("Prioritization Brk
Out").Range("G1:G100").Value

Range("B7:B100").Value = Sheets("Prioritization Brk
Out").Range("A1:A100").Value

Range("C7:C100").Value = Sheets("Prioritization Brk
Out").Range("H1:H100").Value

Range("D7:D100").Value = Sheets("Prioritization Brk
Out").Range("L1:L100").Value

Application.ScreenUpdating = True
End Sub