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.
Thanks
Bookmarks