I want to select multiple Non Adjacent Rows based upon a cell value. I just
don't know how to do it. I envison something like an if then statement. If
(cell value = 1), then select row. It's that simple but I want to select
multiple non adjacent rows at the same time.
My end goal is to select all the rows that have a value of 1 and copy them
and paste them elsewhere.

Filter Auto Filter select 1
Copy and Paste

"avalynch" wrote:

I want to select multiple Non Adjacent Rows based upon a cell value. I just
don't know how to do it. I envison something like an if then statement. If
(cell value = 1), then select row. It's that simple but I want to select
multiple non adjacent rows at the same time.
My end goal is to select all the rows that have a value of 1 and copy them
and paste them elsewhere.

Hi avalynch

If you want to copy all rows with a 1 in a column to another place see
http://www.rondebruin.nl/copy5.htm

See also the manual example below the first code example

--
Regards Ron de Bruin
http://www.rondebruin.nl



"avalynch" wrote in message ...
I want to select multiple Non Adjacent Rows based upon a cell value. I just
don't know how to do it. I envison something like an if then statement. If
(cell value = 1), then select row. It's that simple but I want to select
multiple non adjacent rows at the same time.
My end goal is to select all the rows that have a value of 1 and copy them
and paste them elsewhere.