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.