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!

You have a reply at your other post - please do not multi-post.

Pete

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!

It really wouldn't be a "function" but rather a process of some sort
such as a PivotTable or Data Query.

For instance, you could create a pivot table and use distributor in the
Page field. Once created, you can have Excel automatically generate a
separate "page" for each distributor in the database.

If you already know the names of each distributor, you could use the
Data Import External Data to create a query that bring in only that
data that matches the distributor query.

Good luck.

- John

http://www.johnmichl.com/exceltips.htm

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!

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!

Completely unintentional. Error from when I posted the first one said it
didn't go through and to try it again.

"Pete_UK" wrote:

You have a reply at your other post - please do not multi-post.

Pete

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!