I've got a master list with 100's of items. I have four columns of
information for each item. (Description, supplier, item number, cost). I
want to generate a list on a seperate page by supplier. For example, every
item that is made by ABC company is put on list A (seperate worksheet), every
item made by XYZ company is put on list B (seperate worksheet) and so on. Is
there a macro or formula that I can use for this?

One of the golden rules for data base design is not to have the same
information in more than one place - imagine the complication of having to
update two or three places when a phone number is changed.
If you filter you data (Data | AutoFilter) you will be able to view/print
just the records of a single supplier on the 'master' sheet.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"LrngasIgo" wrote in message
...
I've got a master list with 100's of items. I have four columns of
information for each item. (Description, supplier, item number, cost). I
want to generate a list on a seperate page by supplier. For example,
every
item that is made by ABC company is put on list A (seperate worksheet),
every
item made by XYZ company is put on list B (seperate worksheet) and so on.
Is
there a macro or formula that I can use for this?

Thank you very much that wasexactly what I was wanting to do. Thanks for the
quick response.

"Bernard Liengme" wrote:

One of the golden rules for data base design is not to have the same
information in more than one place - imagine the complication of having to
update two or three places when a phone number is changed.
If you filter you data (Data | AutoFilter) you will be able to view/print
just the records of a single supplier on the 'master' sheet.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"LrngasIgo" wrote in message
...
I've got a master list with 100's of items. I have four columns of
information for each item. (Description, supplier, item number, cost). I
want to generate a list on a seperate page by supplier. For example,
every
item that is made by ABC company is put on list A (seperate worksheet),
every
item made by XYZ company is put on list B (seperate worksheet) and so on.
Is
there a macro or formula that I can use for this?

Else you can use Pivot Table. It is helpfull indeed to view your data
in as a summary.

Thanks,

Shail


LrngasIgo wrote:
Thank you very much that wasexactly what I was wanting to do. Thanks for the
quick response.

"Bernard Liengme" wrote:

One of the golden rules for data base design is not to have the same
information in more than one place - imagine the complication of having to
update two or three places when a phone number is changed.
If you filter you data (Data | AutoFilter) you will be able to view/print
just the records of a single supplier on the 'master' sheet.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"LrngasIgo" wrote in message
...
I've got a master list with 100's of items. I have four columns of
information for each item. (Description, supplier, item number, cost). I
want to generate a list on a seperate page by supplier. For example,
every
item that is made by ABC company is put on list A (seperate worksheet),
every
item made by XYZ company is put on list B (seperate worksheet) and so on.
Is
there a macro or formula that I can use for this?

I'm struggling with the same problem. I have a long list of items that are
grouped by product types, but scattered within the list. This list is
imported to excel from another program that I have no control over, and is
updated from time to time.

What I need is to sort items of different types to different columns on
another worksheet. These columns are then used to populate comboboxes.

Is there a function in excel for this? Also advice on appropriate VBA code
is galdly accepted.

Thanks,

Alerion