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
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
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
[email protected]
"Saxman" <[email protected]> wrote in message
news:[email protected]...
> 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
"Don Guillett" <[email protected]> wrote in news:e5g5f1BgGHA.1324
@TK2MSFTNGP04.phx.gbl:
> You can use a link =sheet1!a2 or a worksheet_change event
This does not appear to work on the same workssheet? Maybe I should have
stated that?
"Don Guillett" <[email protected]> wrote in news:e5g5f1BgGHA.1324
@TK2MSFTNGP04.phx.gbl:
> 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
I got it. I just couldn't think today! =A2 and format the cells to
General.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks