Resolved >>> Data Validation dropdowns (Dependant Lists)

Hi

Im new here so im sorry if im in the wrong thread.

My question is hard to describe.

I am creating a spreadsheet i want it to be that i make a selection from a drop down and this will then narrow the options available in the next drop down.

Say box one you select 'half day' and then the next drop down menu will automatically loose all the data for a 'full day' and only show half day information such as costs for food and room bookings ect.

i have made the drop downs but im not sure what to do next.
sorry if i havent described it well enough.............im not really an advanced excel user so im not sure about technical terms.

thanks in advance for your help

That looks exactly what i wanted

Thank you