Create a linked listing list

Range > Make dependent DD list

This utility allows you to create lists in Excel (LibreOffice Calc), where the choice in one field automatically affects available options in another. This is useful for organizing data and creating interactive forms. The tool provides convenience and accuracy of information.

Screen shot

After application:

Starting this tool

Click YLC Utilities > Range > Make dependent DD list :

Excel:

LibreOffice Calc:

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, actual time savings depends on how often you use Excel (Calc) , the amount of data you work with and how often you use this tool.

Download extensions

You can use the utility Make dependent DD list by installing the extension YLC Utilities .

This feature will be available in all files that will be opened in Excel (LibreOffice Calc).