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

Hi again,
I was in such a hurry before that I didn't check the macro properly

Try this instead (as you see I just quickly edited my previous instruction):

Put cursor in cell B6. Start recording a macro (tools / macro / record...). By clicking on a symbol on the little "macro recorder box" (the one with the stop sign) you shift to "relativ references" (which will be needed here).

Type "yes" (without enter), followed by "arrow right" two times. Now you should by in cell D6.

Now enter the formula =today() in the cell D6. Then (still in D6) run the command "Copy" and after this Edit / Paste special / Values. After this press escape (to hide the area marked for copying).

Stop the recording. Your macro is now ready!

A suggestion is that you assign the macro with a shortcut (for example CTRL + Y).

Now you can just place the cursor in column B (B8 for example) and press CTRL+Y and the job is done!

I really hope it works this time

Kind regards
Bjorn

Thanks Bijorn for ur help,
one more querry that instead of runing macro more often on this file, if u can suggest such thing that when i open the particular file the cell which had returned the date in d column (whatever may be the date) then it should not update the date to today's date. (let say i have mention yes in some cell e.g 10 cells (today), then those 10 cell's d column should show today's date. if I open this file next day then while calculating the formula when u open the file it should ignore those cell in d column which had already mentioned the date)
Thnks Again.....

HI,
creating such a macro would be quite tricky, and on the top of that, you might be needed to adjust the macro yourself if your cells are moved or extended in any way. It is also a solution which might be a little unsure, since any type of mistake/error/systemproblems etc, might cause the date to change to todays date by "accident".

I am not sure what you want to achieve by your new question. I find it even easier to press "CTRL+Y" in a cell to get the complete job done (including the date), instead of typing "Yes" followed by an enter (and in addition have a really complex macro to maintain/write).

I suggest that you stay with the short and easy macro

Kind regards
Bjorn