Okay,I have a new problem dealing with pictures. I have tried to follow the instructions from the McGimpsey & Associates site (http://www.mcgimpsey.com/excel/lookuppics.html) to no avail. I just can't seem to get it all working proper. Basically, what I am trying to do, is make a drop down list show the picture above it. I have tried to change everything, and I am sure I am just a hair away from getting it right. I got the spreadsheet to where it will pull up the "Picture #" in the appropriate box, and even had it delete/hide all my pictures (I say delete/hide because I couldn't get them back after I removed the coding I was working on).
Another nice function I would like would be a button, around cell B74, to erase all the picks and reset the sheet for the next season... it would have to have a prompt to verify the user was absolutely sure they wanted to do that though! But I don't know where to begin on that button issue. Can someone point me in the right direction?
The spreadsheet is too big to attch, so it's hosted at the link below. The sheets involved are NFL Survivor & PicTable. On sheet PicTable, the Names & Pic #'s have already been named PicTable for ease of coding.
http://www.box.net/public/sm77z1dspy
Thanks in advance for the help.
Chris
Bookmarks