I’m a new user looking for help on an Excel formula/macro code.
To demonstrate my scenario, let’s say I have a drop down list with values of “Breakfast, Lunch, and Dinner”. If the user selects breakfast from the dropdown, a unique breakfast menu with items and prices as the columns appears below. If the user selects lunch or dinner, a different menu appears below the dropdown cell.
I wish the formula was easy as: IF(A1=“Breakfast”,PASTE(BreakfastMenu) )
Thank you in advance for your help!