Is there a macro that would make it possible to lookup a certain name in a
column and anytime it finds that name it will copy a range of cells and paste
it into another worksheet? I.E. anytime the name Jim Smith is found in the
range A5:A200 it returns a range of cells next to it...if Jim Smith was found
in A5, it would copy cells C5:FN9 and paste them in a specified location on
another sheet

Right now I have it copying all colmns from the master sheet and if the name
is not assigned to that project it will return a 0, then I have a macro to
hide all rows that equal 0. Is there a better way to do this? Any hints on
the best way to do this?
Thanks!