Thread
:
Exact Copy
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Exact Copy
You can use a link =sheet1!a2 or a worksheet_change event
if target.column<2 then exit sub
target.offset(0,4).value=target
--
Don Guillett
SalesAid Software
"Saxman" wrote in message
...
If I type for example, '5/2' in a cell formatted as text, how can I
simultaneously make a duplicate of this data in another cell?
TIA
Reply With Quote