Excel 2007 - Mandatory single cell input with unique value -
i working in phone call center , create daily reports of tickets. daily study contains tickets(logged calls in system) , queue(language) have been logged. ex.: "call12121/im12121212 - it/fr/en/ro queue"
the excel file looks sth this:
...............a.......... |...............b................|..............c..............|
1 .....ticket nr ....|.... language fr.....|.....language it....|
2 ....im123456......|..............1.................|..............................|
3.......................... |.................................|..............................|
so, need is, basically, when agent completes excel study ticket number (e.g. im1213123
) must come in value queue , value number 1
. after queue/language cells row locked/blocked , agent not able come in other values.
for example: excel sheet looks empty above one. agent enters/copy-paste ticket number in cell in column ticket
, after needs come in queue/language value. , in case doesn't come in value queue (a windows guess) prompt him, when tries add together value in other cell(except corresponding one), has completed study correctly (or that)
example: column named ticket
column b named fr
, column c named it
. agent , need finish study , lets have single ticket report. open excel daily study file -> paste ticket number in a2 cell, , after finish language/queue column. lets come in 1 in b2 fr language. , if want come in 1 on c2 show me error or rest of row blocked not allow come in multiple values in language part in report. mean 1 ticket (imxxxxx) can't created on both fr , queue. 1 queue allowed 'selected'. 1 language able come in value.
so above example: im123456, should come in single value, either 1 fr, either 1 it, can't both , if none come in , move on next row or trying save file receive warning cell values have not entered. same thing row , same next 1 etc. ticket nr entered in row, 1 value entered on 1 of language columns row.
i know part of excel macros , vb programming(where have no knowledge) can please give me code or maybe should read more etc ?
i working in excel 2010.
you utilize dropdown list instead , have 1 field called language
check out : http://www.excel-easy.com/examples/dependent-drop-down-lists.html
excel-vba excel-formula excel-2010