Hi,

I am trying to write a macro that will copy row data from a 'master' sheet
to multiple sheets in workbook. I can't figure out the function to look at a
specific column in each worksheet and compare that data value to my 'master'
sheet.

Here is my example. My 'master' sheet has quantity counts of apples,
oranges and bananas from each day. I want to copy my 'apple' rows to the
'Apple Counts' worksheet, and by 'orange' rows to my 'Orange Counts'
worksheet and etc. So I am needing help with the function that could look at
my entire workbook or each worksheet, comparing the value of my "Fruit"
column in my master sheet to the same column in each worksheet. If found,
then the row is moved to that worksheet. Hope that makes sense?

Any help would be much appreciated.

-Wesley