Thanks Bjorn for ur help,
I have created the simple macro as u suggested, but the problem is that when i run the macro by using the shortcut keeping the cursor in B coloumn's (let us take B8 ) cell then this cell's data get's update to yes but the in D coloumn ( i.e D8 ) won't get update to date. plz help...