generate part list

[stefsjenko]

Hello

I'm designing a product. the part list was made in excel.
The product has the following structure:
assemblyA:
- 3x part1
- 2x part2
- 4x part3
- 1x subassemblyX

subassemblyX:
- 2x part 1
- 4x part 4
- 3x part 5
...

the design consists of 8 assemblies which are all fabricated by multiple parts and subassemblies.
when a assembly is chosen in the order list (dropdown list), a list of all used parts (no subassemblies)should be generated.

Is this possible in excel or only by using Visual basic or Acces?

Thanks in advance
Stef

[punna111]

Hi stef,

Please attach a sample sheet. and please explain what you want exactly in the sheet.

Regards,
PRB.

[stefsjenko]

partlist example.xlsxHello punna111

I attached a sample cheat as requested.
In this sheet you can find the structure i was talking about.
In the yellow cel there is a dropdown menu. this is not te problem.
When you choose for example assemblyA, the partlist for this assembly has to be generated.
I manualy filled in the partlist for assembly A in the blue cells.
This has to be generated automatically.

grts
Stef

[punna111]

Hi stef,

ok got it..but still i have a query.
If i select "assembly A" in column "I", where do you want the below data.(as per your previous post blue cells in sheet)

part1
part2
part3
part1
part4
part5

[stefsjenko]

Hello punna111

I prefer to have the list on a clean sheet. But the position is not that important.

grts
Stef

[punna111]

Hi Stef,

Please find the attached workbook.
I have given the data validation in sheet2(BLAD 2).


please let me know if you have any further queries.


If you like my post please click on * button left side of this post(<---), that will encourage us to give quick and proper solutions.

[Harribone]

Is this along the lines of what you want?

Assembly List.xlsx

[stefsjenko]

Hello Harribone

That's not completely what i meant but it could be usefull
thanks for your contribution

grts
Stef