I have a list of vendors (organized by vendor number) in Column B of my worksheet. Column E is a list of the # of days it took the vendor to get product to me.

I need a macro that will search for like values in column B and then average the values in Column E of the corresponding Rows. I need it to report the result in Column F in each of those Rows.