Table data depending drop-down lists

[Rhamta]

I have a file with several calculations, I have two pages I need to relate, in one I have data from several locations, and the other several options and Lifting Index calculation for scenario analysis. I want to include depending drop of lists on the second one, so user can only choose from available locations, and the specific options for that location. I want the drop-off lists to show unique values but I do not want to do a specific table each location and options, I want it to be compunded from locations table. Each table has much more data then the one used here.

My first table:




[TABLE="width: 1068"]
<tbody>[TR]
[TD]Production Line[/TD]
[TD]Generic Location[/TD]
[TD]Location[/TD]
[TD]Improvement[/TD]
[TD]Improvement Description[/TD]
[TD] Platform Height Regarding Plant Floor (inch.)[/TD]
[TD]Minimum lifting table Height (inch.) *[/TD]
[TD]Maximum lifting table Height (inch.) *[/TD]
[TD]Average lifting table Height (inch.) *[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]L3 - Blender[/TD]
[TD]L3 - Blender Left[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD] 87.00[/TD]
[TD] 9.50[/TD]
[TD] 35.00[/TD]
[TD] 22.25[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]L3 - Blender[/TD]
[TD]L3 - Blender Front[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD] 87.00[/TD]
[TD] 14.50[/TD]
[TD] 39.75[/TD]
[TD] 27.13[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Bag Dump 1[/TD]
[TD]L4 - Bag Dump 1[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD] -[/TD]
[TD] 18.00[/TD]
[TD] 53.00[/TD]
[TD] 35.50[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Bag Dump 2[/TD]
[TD]L4 - Bag Dump 2 - Red Lifter[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD] -[/TD]
[TD] 20.00[/TD]
[TD] 30.50[/TD]
[TD] 25.25[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD] -[/TD]
[TD] 19.00[/TD]
[TD] 53.00[/TD]
[TD] 36.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Bag Dump 4[/TD]
[TD]L4 - Bag Dump 4[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD] 105.00[/TD]
[TD] 18.00[/TD]
[TD] 53.00[/TD]
[TD] 35.50[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - Gray Lifter[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD] -[/TD]
[TD] 16.00[/TD]
[TD] 32.00[/TD]
[TD] 24.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - White lifter[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD] -[/TD]
[TD] 16.00[/TD]
[TD] 28.50[/TD]
[TD] 22.25[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Premix[/TD]
[TD]L4 - Premix[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD] 62.00[/TD]
[TD] N/A[/TD]
[TD] N/A[/TD]
[TD] N/A[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]L3 - Blender[/TD]
[TD]L3 - Blender Front[/TD]
[TD]Restore[/TD]
[TD]Restored Rotation[/TD]
[TD] 87.00[/TD]
[TD] 14.50[/TD]
[TD] 39.75[/TD]
[TD] 27.13[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Bag Dump 2[/TD]
[TD]L4 - Bag Dump 2 - Red Lifter[/TD]
[TD]Replacement[/TD]
[TD]Redesign with Rollers[/TD]
[TD] -[/TD]
[TD] 11.25[/TD]
[TD] 36.20[/TD]
[TD] 23.73[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]Replacement[/TD]
[TD]Redesign with Rollers[/TD]
[TD] -[/TD]
[TD] 11.25[/TD]
[TD] 36.20[/TD]
[TD] 23.73[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - Gray Lifter[/TD]
[TD]Replacement[/TD]
[TD]Lower Footprint Lifting Table[/TD]
[TD] -[/TD]
[TD] 7.25[/TD]
[TD] 32.20[/TD]
[TD] 19.73[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - White Lifter[/TD]
[TD]Replacement[/TD]
[TD]Lower Footprint Lifting Table[/TD]
[TD] -[/TD]
[TD] 7.25[/TD]
[TD] 32.20[/TD]
[TD] 19.73[/TD]
[/TR]
</tbody>[/TABLE]


My second table:[TABLE="width: 983"]
<tbody>[TR]
[TD] Line[/TD]
[TD] General Location[/TD]
[TD]Dumping Station[/TD]
[TD] Configuration (Original / Improved)[/TD]
[TD]Improvement Description[/TD]
[TD]Calculated Point Description[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]L3 - Blender[/TD]
[TD]L3 - Blender Front[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]L3 - Blender[/TD]
[TD]L3 - Blender Left[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]L3 - Blender[/TD]
[TD]L3 - Blender Front[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]L3 - Blender[/TD]
[TD]L3 - Blender Left[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 1[/TD]
[TD]L4 - Bag Dump 1[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 1[/TD]
[TD]L4 - Bag Dump 1[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 4[/TD]
[TD]L4 - Bag Dump 4[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 4[/TD]
[TD]L4 - Bag Dump 4[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - Gray Lifter[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - Gray Lifter[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - White Lifter[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - White Lifter[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 2[/TD]
[TD]L4 - Bag Dump 2 - Red Lifter[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 2[/TD]
[TD]L4 - Bag Dump 2 - Red Lifter[/TD]
[TD]Original[/TD]
[TD]None - Current[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]L3 - Blender[/TD]
[TD]L3 - Blender Front[/TD]
[TD]Restore[/TD]
[TD]Restored Rotation[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]L3 - Blender[/TD]
[TD]L3 - Blender Front[/TD]
[TD]Restore[/TD]
[TD]Restored Rotation[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]Replacement[/TD]
[TD]Redesign with Rollers[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]L4 - Bag Dump 3[/TD]
[TD]Replacement[/TD]
[TD]Redesign with Rollers[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - Gray Lifter[/TD]
[TD]Replacement[/TD]
[TD]Lower Footprint Lifting Table[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - Gray Lifter[/TD]
[TD]Replacement[/TD]
[TD]Lower Footprint Lifting Table[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - White Lifter[/TD]
[TD]Replacement[/TD]
[TD]Lower Footprint Lifting Table[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Scale C[/TD]
[TD]L4 - Scale C - White Lifter[/TD]
[TD]Replacement[/TD]
[TD]Lower Footprint Lifting Table[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 2[/TD]
[TD]L4 - Bag Dump 2 - Red Lifter[/TD]
[TD]Replacement[/TD]
[TD]Redesign with Rollers[/TD]
[TD]Standard Pallet Height 40"Wx48"Lx50"H at TOS[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]L4 - Bag Dump 2[/TD]
[TD]L4 - Bag Dump 2 - Red Lifter[/TD]
[TD]Replacement[/TD]
[TD]Redesign with Rollers[/TD]
[TD]Last Pallet Row at TOS[/TD]
[/TR]
</tbody>[/TABLE]


Practically I want all the inputs of the first 5 colums of this one to be a drop off menu based on the data of the previous one