filtering data

[ady_mech]

Hello there

Let's say I have 3 columns of data, 100 rows. I want to filter and copy the data from every 3rd row to a separate worksheet. How can I do that?

Thx for your help.

[ady_mech]

Hello there

Let's say I have 5 columns, 100 rows of data. Cells in Col A are colored differently. I want to show the data which corresponds to cells with a particular color in Col A. How can I do that?

thx to all the readrs