View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Broten Ken Broten is offline
external usenet poster
 
Posts: 1
Default Copy Data on click event

tI have a need to click on a cell containing a text string then have the
string copied to another cell and a 2nd cell set to a different value.

I have a table of string values. I want to click on any cell in the 1 st
column and have the cell content copied to a single fixed location cell. Then
I want a string constant set in a different cell. For the remaining columns
in the table the action is the same except that the constant string set in
the 2nd target cell is different.

How do I do this?
--
Ken Broten