Thanks. I need for this to be done programatically. I am turning this over
to a user and this report is created each 6 weeks. All they will do is click
a menu button and the report will be created.
--
Robert Hill



"merjet" wrote:

You don't need VBA code for that. Use the menu Data | Filter. Then
filter the range to show only rows with, say, T. Copy the filtered
range (or only part of it) elsewhere. The hidden rows will not be
copied.

Hth,
Merjet