IS it possible to have a combo box wit 13 items(names of different wards) and 3 options box...(breakfast,lunch tea)...so when ward A + breakfast are chooser a hyperlink appears in a cell..Which will link to that spreadsheet
So what you want to do is have a list of selected ward types and either breakfast, lunch, or dinner? then want to compare the selection and then what??
This can be achieved by a bit of VB programming-are you familar with VB at all? Basically I would use a series of "If" statements to compare each option to determine what outcome you require.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
