I am creating a report in Excel. I have Sheet1 with a list of names.
Accross from each name is a row with codes such as 'T' or 'D'. I need to
grab all the names that have a 'T' in their row and put the name values in
another worksheet where I am creating my report. We will call this Sheet2.
This seems so simple but I am new to Excel and do not know how to use VBA to
loop through a worksheet looking for certain values and using them somewhere
else. Any help is greatly appreciated.
--
Robert Hill

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

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

Turn on the macro recorder. Use the filtering process I described
above. Turn off the macro recorder. Then you will have the VBA code
that can be rerun with a couple of clicks.

Hth,
Merjet