Hi,

In the "Priortization Brk" tab column G has the value "Commercial" - each
cell has only 1 value but it could be either "Commercial" "TELCO" "Retail
Sales" and et cetera.

For example:

A1: Project B1: Project Name ... G1: Department (Commercial, TELCO and et
cetera).

So I want to pull from "Priortization Brk" paste the the rows stated below
but only where column G = Commercial.

Thanks


Mike



"Rick Rothstein" wrote:

Where is the word "Commercial" located... in any cell within the row or in
the cells of a particular column? Also, is the word Commercial the only word
in the cell or can there be other text in the cell with it? Also, I'm
assuming when you say copy the row, you mean rows A thru D, correct?

--
Rick (MVP - Excel)


"mike" wrote in message
...
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