PDA

View Full Version : save/paste column



kamalmalek
02-03-2012, 10:15 AM
dears,
i have simple issue

users update some info in column A
I need to copy all in A timely and paste in column B but without duplicate
i need to update TIMELY and not affect "small or big letter"
as below:

A B
JOU JOU
JOU Larry
Larry micle
Larry
larrY
micle

Bob Phillips
02-03-2012, 10:41 AM
Use Advanced Filter, it has a unique values option.

kamalmalek
02-03-2012, 12:39 PM
thanks XLD
but i need timely,
like if i use advance filter, it is okey but "then" if client add same cell before will not be effected in advance filter list,
i need same below:
A B
JOU JOU
JOU Larry
Larry micle
Larry
larrY
micle

Bob Phillips
02-03-2012, 05:29 PM
So you code the AF, and use a change event to trigger it.