How do I Select Multiple Non Adjacent Rows based on a cell value?

[avalynch]

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.

 

[Teethless mama]

Filter > Auto Filter > select 1
Copy and Paste

 

[Ron de Bruin]

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