Date Stamp error

[dagindi]

I am using the following macro to date stamp cells in F based on "Yes" in E.

Please Login or Register  to view this content.

When I simply type "Yes" in E i get the current date in F. This is exactly what I want to happen.

Problem is when I do a mass update by either copying "Yes" from another cell and pasting it to multiple cells or selecting multiple cells and pressing delete, i get a debugging error and cannot figure out why.

Any help would be greatly appreciated.

[dagindi]

I forgot to attach a sample of the sheet.

[trucker10]

keep it simple

Please Login or Register  to view this content.

[dagindi]

Trucker,

Thanks for the response.

While your solution is simpler then mine and it solves the issue of working with multiple cells at once, it doesn't do exactly what I need it to do.

I only want the date to appear if "Yes" is entered in the column.

[dagindi]

I have this code as well but again it covers the entire column range of E and will populate the date in F regardless of what is typed in E

Please Login or Register  to view this content.

[trucker10]

You can set And Target.Value = "Yes"

Please Login or Register  to view this content.

[dagindi]

Better, but still getting a run time error 13 and type mismatch.

See attached

[dagindi]

"Bump no response"

[EK1]

I tried you file and while I'm still quite the noob....I think I've fixed it somehow.

Try this code instead of what you had before.

Please Login or Register  to view this content.

[DonkeyOte]

Perhaps you want something along the lines of:

Please Login or Register  to view this content.

still not 100% watertight but I suspect does what you want - though not clear what should happen if something non-blank but non-YES is entered into Col E

[dagindi]

DonkeyOte,

Well Done!!

You say it might not be "still not 100% watertight" but if the Titanic had this code it would still be afloat...

After studying your code and getting a basic understanding of how it works I was able to modify it to the following:

Please Login or Register  to view this content.

So now when I add any comment in Column A, such as "Work", "Personal", "Travel" etc I get the date it was entered or "started".

Column E gets a "Yes" once what ever the task/question is gets a response or completed.

Column F gives me a time elapsed total.

Once again thank you so much for solving this problem.

Pats on the back for everyone!!!