title: combobox values and linking them to another cell within same worksheet without using VBA
body: <p>I have a combobox on one page in worksheet it is linked to data in another tab same worksheet, once user picks their selection from the combobox I would like that selection (value) to be auomatically copied to another cell on a different tab.  I do not want to use VBA and of course a simple =sheet1:A12 does not work because the combobox does not actually sit in any particular cell. Example user goes to combobox selects the word "terminal", now I would like the word "terminal" to end up in another cell on a different tab.  can this be done without coding?  if yes how would I go about doing that</p>