hi, I'm a noob at programming and this should be a breeze for the
gurus.
I need to search down a column for values 100000 and if found, copy
the whole row to sheet 2. It should loop through all the data in the
table until the last row.
simple as that.

thanks!!