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.