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