Dim rng as Range, cell as Range
With worksheets("Sheet1")
set rng = .Range(.cells(1,1),.cells(rows.count,1).End(xlup))
End With
for each cell in rng
if cell.Font.size = 12 then
cell.EntireRow.copy Destination:= _
worksheets("Sheet2").Cells(cell.row,1)
end if
Next
set rng = worksheets("Sheet1").cells.Find("Target" _
Lookin:=xlValues,LookAt:=xlPart)
if not rng is nothing then
sAddr = rng.Address
do
rng.Entirerow.copy Destination:= _
worksheets("Sheet2").Cells(rng.row,1)
set rng = cell.FindNext(rng)
Loop until rng.Address = sAddr
end if

--
Regards,
Tom Ogilvy


"Karlos" wrote in
message ...

I am struggling with a export problem purely due to the size of task.

I have over 50000 rows of text in excel. I would like to copy all the
text that is a certain font size to a new sheet, in th same position as
found, this would leave behind all other data.

Another macro would bring out all data based on a word.

Effectively the fonted data would copy first then the 2nd macro would
look for an instance of the target word, if found then copy that word
to under the previous fonted data. The first macro would then continue
to look for more fonted data and so on.

Can any one help I am on a very tight schedule and lack of sleep is
driving me mad.


--
Karlos
------------------------------------------------------------------------
Karlos's Profile:
http://www.excelforum.com/member.php...o&userid=28649
View this thread: http://www.excelforum.com/showthread...hreadid=483612