Calc timesheet

hi all,

we use calc as our timesheet our architecturial company.
In the field we use to describe the work done for a certain time, we have a drop menu with certain items we can choose from.
I would like to know if it would be possible for the list to show certain options based on information entered in a previous field? So for arguments sake I enter “A” into a field, I only want option 1,2,5 and 7 to show and when I enter “B” I want option 2,7,9 and 10 to show
thanks in advance for any help!

Use function INDIRECT() for named ranges
Two dropdown lists.gif

Thanks for pointing me in the right direction JohnSUN, am going to look up this function right now

Wow! Thank you very much JohnSUN!
that is really generous of you, thanks very much for the animation, it explains it perfectly!
thanks again and i really appreciate your help!

I’m sorry :frowning: . This cartoon has been in the message since the previous evening, but due to a bug on the site was not visible. Was glad to help.