Calc timesheet

[asteynberg]

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!

[JohnSUN]

Use function INDIRECT() for named ranges

[asteynberg]

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

[asteynberg]

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!

[JohnSUN]

I’m sorry . 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.