Ok, here is what I am trying to do. I want to create and automation using Excel to make setting up a magazine template easier. I receive the file in an Excel worksheet listing out what ad goes where, ad size, page number, etc (i.e. page 1, Grocery Store, Half Page, Bottom). What I want is for the client to be able to click in a drop down box to select the ad size and placement (I already know how to make the drop down boxes). However, this is where it's tricky for me. I want to make the drop down boxes more intuitive and I would the column containing the ad name to have a drop box linking to a master list so that when I click it, the ad image comes up. Does that make sense?
Any help would be sooo appreciated! I've been studying a bunch of tutorials and even found some for the picture drop down part but I can't get it to work for multiple pictures/columns/rows. The macro hides the rest of the pictures so only one image shows up. I followed this tutorial http://www.mcgimpsey.com/excel/lookuppics.html based off a suggestion I saw in another thread.
Thanks in advance!
Bookmarks