pls can somone help me. I have posted on here previously but the advice
> given didn't work. I know what I want doing can be done but I just don't
> know how to do it! I also think I will have to email my spreadsheet to
> someone as my explanation is not very straight forward.
>
> So, in the spreadsheet I have two tabs, the main page, where I am creating
> my formulas and data where I have all my “lists” created as named ranges.
>
> So in the main page tab in cell I4 I have created a drop down list which
> gives names of operations. This list is created from the “operations” named
> range on the data sheet (cells A3:A20).
>
> What I want to happen is, if for example I select Cholesystectomy from the
> drop down list in I4 on the main page, I want cell J4 to offer me a drop down
> list based on the named range of chole which is on the data sheet (T3:T5).
> If I selected Nissen Fundoplication in from the drop down list in I4 then I
> want cell J4 to offer me a drop down list based on the named range of nissen
> on the data sheet (U3:U6), then if I selected Hellers in I4 I want J4 to give
> me the drop down list of hellers and so on.

Hi Leisl

I can understand what you need your spreadsheet to do and so I have allocated your post to an Excel trainer who I think will be able to help you.

Hopefully he will have an opportunity to look at your post tomorrow and get back to you then.

Regards
Amanda

Please e-mail the spreadsheet to forum AT microsofttraining.net so one of our Excel trainers can have a look. Thanks.

Leisl

Thank you for your question. The solution to the task you want to perform is not straight forward as it determined on many variables.

One of them is your knowledge of Excel Skill Sets covered in our courses as I notice you have not attended any of our courses. However probably have the skills necessary still I would like to check. The following skillsets would be required.

Absolute Referencing, Data validation by list, Nested If Statements & possible Vlookups.

Please advise me of the extent of your knowledge on these skillsets

The other major factor is the amount of items on each of the list, which will determine what methodology I would recommend.

Look forward to your reply.

Regards
Thomas Kan

BEST Training