I have been researching this for awhile now, and can't figure out how to do it. Basically I have one sheet that has 23 columns - one of those columns being "Responsible Party". I want to ONLY copy the rows of data if the responsible Party has the name "Joe Smith" (for example). I do NOT want to use an autofilter - I know how to add that in macro - but instead would rather use a for loop. Any ideas.
Example of Sheet 2
<tbody>
</tbody><colgroup><col><col><col span="2"><col></colgroup>
Example of Sheet 2
<tbody> </tbody> | ||||||||||||||||||||||||||||||||||
Below is what I want to show up on Sheet 1 (from Sheet 2 Above) USING A MACRO | ||||||||||||||||||||||||||||||||||
<tbody> </tbody> | ||||||||||||||||||||||||||||||||||
please help if you have any ideas!! I've tried multiple different ways. | ||||||||||||||||||||||||||||||||||
<tbody>
</tbody><colgroup><col><col><col span="2"><col></colgroup>