[h=4]Good morning.[/h]I’m creating a document name for users:
Standort-Gebäude-Geschoss-Planart-SPA1-SPA2-Variant.xxx
Each parameter of the document name is in extra cell of the "Dokument Name" sheet.
Paramters „Planart“, „SPA1“ and „SPA2“ are chosen in a table of the "Planart, SPA1 and SPA2" sheet with more 2600 rows.
For choosing values I applied Filter. What option I choose as “Planart”, only its possible “SPA1” and “SPA2” I can choose. And than what "SPA1" option i choose, only its possible "SPA2" I can choose. Than I choose "SPA2". Finally I get one row with Planart, SPA1 and SPA2 attributes/values .
Base on the choice through Filter I get also shortcuts of this attributes in neighbouring columns (columns C, E and G)under the table-heading row (In this row is turned on Filter function.) This shortcuts I need automatically adjust to the document name in cells H10, J10 and L10.
The table area in sheet "Planart, SPA1 and SPA2" is B4:H2624. Row 4 is heading of the table.
Some SPA1 and SPA2 attributes are empty. There is “-“ in the table. Than the parameter in the document name should be blank.
1. Please could you help me with automatic function/macro to add chosen shortcuts from the table into cells H10, J10 and L10 of the sheet "Dokument Name".
2. Another solution - lists of values in the cells H10, J10 and L10:
Is it possible to change automatically the list of values in J10 (SPA1 parameter) base on chosen value in the list of the cell H10 (Planart parameter). And also is it possible to change automatically the list of values in L10 (SPA2 parameter) base on chosen values in cells H10 (Planart parameter) and J10 (SPA1 parameter)?
Thank you very much for your help in advance.
Michal
Standort-Gebäude-Geschoss-Planart-SPA1-SPA2-Variant.xxx
Each parameter of the document name is in extra cell of the "Dokument Name" sheet.
Paramters „Planart“, „SPA1“ and „SPA2“ are chosen in a table of the "Planart, SPA1 and SPA2" sheet with more 2600 rows.
For choosing values I applied Filter. What option I choose as “Planart”, only its possible “SPA1” and “SPA2” I can choose. And than what "SPA1" option i choose, only its possible "SPA2" I can choose. Than I choose "SPA2". Finally I get one row with Planart, SPA1 and SPA2 attributes/values .
Base on the choice through Filter I get also shortcuts of this attributes in neighbouring columns (columns C, E and G)under the table-heading row (In this row is turned on Filter function.) This shortcuts I need automatically adjust to the document name in cells H10, J10 and L10.
The table area in sheet "Planart, SPA1 and SPA2" is B4:H2624. Row 4 is heading of the table.
Some SPA1 and SPA2 attributes are empty. There is “-“ in the table. Than the parameter in the document name should be blank.
1. Please could you help me with automatic function/macro to add chosen shortcuts from the table into cells H10, J10 and L10 of the sheet "Dokument Name".
2. Another solution - lists of values in the cells H10, J10 and L10:
Is it possible to change automatically the list of values in J10 (SPA1 parameter) base on chosen value in the list of the cell H10 (Planart parameter). And also is it possible to change automatically the list of values in L10 (SPA2 parameter) base on chosen values in cells H10 (Planart parameter) and J10 (SPA1 parameter)?
Thank you very much for your help in advance.
Michal
