Firstly, Welcome to The Code Cage, why would you want a duplicate value
in the next column when you can use the value from your dropdown
(assuming its a data validation list), anyway you don't need code for
that you can simply use =A1 in B1 if your dropdown is in A1.

Tulsi;324817 Wrote:
Hello,

Could somebody give me a macro for copying a particular value from a
dropdown list into a next column.

For example:

If I select "1" (from the dropdown list) then paste "1" to next
column(same row) ,
If I select "2" (from the dropdown list) paste "2" to next column(same
row) on deleting the previously selected option (i.e, "1")

Please help me in writing this Macro.:Blink
Thanks


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90769