You might be able to use a pivot table. Create the pivot placing your
distributor at the top and then use Show Pages to create seperate sheets for
each distributor...
--
HTH...

Jim Thomlinson


"plunk25" wrote:

I have a master spreadsheet with distributor, product, and cost listed. I
would like to have a separate worksheet for each distributor and populate
each sheet with only the data from that distributor. What function would i
use?

Thanks!