Hi all,
In column D (range D8 to D27) i have a drop down list, which when you select a value from will enter a code into another column N (range N8 to N27)
The problem i am having is if N8 to N27 already has a value in it,..and if N8 or any other cell in that range is changed later on (by choosing a different option from drop down list in column D) then the values in the cells after are changed by one (plus one), but i don't want those to change as well. How can i prevent this from happening?
Bookmarks