Generating a list
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? |
Generating a list
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? |
Generating a list
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? |
Generating a list
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? |
Generating a list
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 |
All times are GMT +1. The time now is 04:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com