MS Excel Issue
Posted on 2012-09-01
I have a 2010 spreadsheet that I am working on that is working great.
I have column on the sheet that contains a list of items. That list is used in another column so I can choose (by drop down box) from the list of items I defined.
Depending on what is choosen from the drop down box another cell is changed to indicate the choice. If works great. I can enter my list. The drop downs get changed when I make a change to the list and I can pick different items which update the cell correctly. In other works if I choose item1 the cell is displayed as Item1. If I change the drop down to Item2 then the cell changes to Item2.
The problem is when I copy the worksheet. The formulas as correct. The drop down list is correct but when I make a choice from the list my cell is not populated. The formula points to the correct reference, but the choice is not displayed. If I go to the formula for the reference and hit enter (no changes) it then updates. I do not want to go though this exercise everytime I copy this worksheet.
Hopefully I can get an easy answer to this problem and hopefully you can understand what I am trying to do.