I have a spreadsheet with 2 sheets in it. The first sheet is a form with a drop down menu with many selectable items. Once an item is selected, there are a handful of other cells that populate thru vlookups based on what was selected. Sheet 2 is all the data for sheet 1.
I want to add a button on sheet 1 that will execute the correct image link associated with whatever was selected from the drop menu.
I know I could implement this in Access, but not everyone that will use this has Access.
Thank you.
I want to add a button on sheet 1 that will execute the correct image link associated with whatever was selected from the drop menu.
I know I could implement this in Access, but not everyone that will use this has Access.
Thank you.