Is it possible to set up a pull down menu which changes multiple cells on a spreadsheet? I basically wanted to set up profiles for several products. I want to be able to choose between my products with a pull down menu, which would then change the profile on the page. For example, I have two products A and B. Each product has several categories (ie, Date of Purchase, Price, Manufacturer, etc.). I want these categories to change when I choose between products A and B from the pull down menu.

I hope that's clear. Thank you in advance.