Dematic,

Thanks for the additional information. There are a couple of ways to go
about this. Perhaps the easiest and quickest is by using Excel's data
filtering feature. I recommed the following steps:

1) Select row 1, then Insert a new row of blank cells (Click on InsertRows);
2) Select all of the columns that contain data, then choose
DataFilterAutoFilter;

A drop down arrow will now appear in each cell of Row1.

3) Select the drop down arrow in Cell A1, then choose the "R". As soon as
you do that, only rows where the value in column A is equal to "R" will be
visible.
4) Manual select the "filtered data" that is displayed; Copy and Paste the
filtered data to a blank worksheet. Only the filtered data will be copied.
Rows where the value in Column A is blank, or G, or anything except an "R"
will not be displayed or copied. It's as though they don't exist. You can
restore your data by selecting the drop down arrow and choosing "All".

It's a rather simple solution that doesn't involve the use of any macros.
Hope this helps. Please do let me know if you feel this is helpful or not.

Mike

"Dematic slave" wrote:

I need too create a summary page that takes a particular list of items on one
sheet and condenses them on a different summary sheet.
example:
if cell A1 is an "R" then copy B1, C1 & D1 to the FIRST row of the report.
If cell A2 is a "G" do not list it.
If cell A3 is an "R" then copy B3, C3 & D3 to the SECOND row of the summary
page. and so on to the end of the original list.