create a summary page that will take a list and remove empty rows

[Dematic slave]

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.

 

[MikeT]

Dematic,

If you can provide slightly more information, I might be able to assist.
There are likely to be several approaches...

1) Is the "different summary sheet" in the same wkbk as the source data? or
is the summary sheet in a different wkbk?

2) Is it possible for A1 to be "R" and A2 to be "G" on the same row of data?
or do you use either an "R" in A1 or a "G" in A2?

3) Are there any blank rows in your source data sheet?

4) Are there any situations when A1, A2, A3 are all blank cells on the same
row?

I'd be happy to take a look at a copy of your wksht if you'd like, or I'll
do my best to assist you via this forum.

Best Wishes, Mike

 

[Dematic slave]

Mike,

1) They are in the same wrkbk
2) No, A1 & A2 are on different rows. I am checking one column per row for
the letter "R".
3) Yes, there are blank rows in the source data.
4) A1, A2 & A3 can all be blank, but are in rows 1,2 & 3 respectively.

I will always go to the same column in every row looking for the letter "R"

I appreciate your assistance.

 

[MikeT]

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 Insert>Rows);
2) Select all of the columns that contain data, then choose
Data>Filter>AutoFilter;

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