take a look at help on the advance autofilter,

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Muskrat24" escreveu:

That Kinda helped me. Is there a way that when i make changes to the first
sheet, like switch some options to "yes", that it will automatically update
to the second sheet? Also I have numbers referenced on the first page, how
they be referenced on the second sheet to the first?

"Marcelo" wrote:

on previous post please consider past = paste.

sorry

--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"Marcelo" escreveu:

OK, you can use the autofilter to filter it, select the area, press f5,
special, visible cells only, copy and past to another sheet.

you can automatic recording a macro.

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo