Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search Formula to collate BOM Data
I know this is not the best way to go about this but..... I have a matrix
where Row 'A' is a list of products and Column 'A' is a list of parts and where parts are used in particular products, the quantity is identified in the cell that intersects the product and part. I want to be able to list all the parts and their quantities that are used in a selected product. Is there a formula or string that will enable me to do this? Thanks Peter |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search Formula to collate BOM Data
hi, Peter !
I know this is not the best way to go about this but.. I have a matrix where Row 'A' is a list of products and Column 'A' is a list of parts and where parts are used in particular products the quantity is identified in the cell that intersects the product and part. I want to be able to list all the parts and their quantities that are used in a selected product. Is there a formula or string that will enable me to do this? it might depends on how/where/who/when/... a "product selection" is made -???- - format conditions ? - autofilter / advanced filter ? - pivot tables (page field) ? - macros ?... formulae ? (needed to know: how/where/who/when/... a "product selection" is made) regards, hector. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search Formula to collate BOM Data
I basically want to have a separate sheet within the same workbook where I
can select a product from a dropdown list (related to the BOM) and be able to list all the parts used in that product. I can then print out this page as the new Bill for that product. I will use this where parts or costs change so I can have up to date costing sheets. Obviously the BOM has all parts and all products in a x-y matrix. I currently do not have any filters, macros, pivot tables or anything at this point. I know that a database aould be better to do this with but just thought there might be a way of doing it with excel. Thanks Hector Peter "Héctor Miguel" wrote: hi, Peter ! I know this is not the best way to go about this but.. I have a matrix where Row 'A' is a list of products and Column 'A' is a list of parts and where parts are used in particular products the quantity is identified in the cell that intersects the product and part. I want to be able to list all the parts and their quantities that are used in a selected product. Is there a formula or string that will enable me to do this? it might depends on how/where/who/when/... a "product selection" is made -???- - format conditions ? - autofilter / advanced filter ? - pivot tables (page field) ? - macros ?... formulae ? (needed to know: how/where/who/when/... a "product selection" is made) regards, hector. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search Formula to collate BOM Data
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i collate data from different sheets in one sheet? | Excel Discussion (Misc queries) | |||
Collate data from many workbooks | Excel Discussion (Misc queries) | |||
Excel 2002: Can Vlookup formula search for data with two reference | Excel Discussion (Misc queries) | |||
How do I collate (match-up) one column's data with another? | Excel Worksheet Functions | |||
How do I search a data range for a particular value then collate . | Excel Discussion (Misc queries) |