In the attached file in E column you find this names "AKOLA-MANDI, KARANJA-MANDI ,KHAMGAON MANDI, MANGARULPIR MANDI ,AMARAVATI MANDI"
if i want to copy one of that five names for example i want to copy AKOLA-MANDI to any active cell or suppose cell E44 in before sheet
which i mentioned in attached file, it means when i press key combination ctrl+l then copy paste AKOLA-MANDI to active cell,
when i press key combination ctrl+t then copy paste AMARAVATI MANDI to active cell,
when i press key combination ctrl+k then copy paste KARANJA-MANDI to active cell,
when i press key combination ctrl+h then copy paste KHAMGAON MANDI to active cell,
when i press key combination ctrl+m then copy paste MANGARULPIR MANDI to active cell,
so please provide VBA code for above operation
Bookmarks