Insert static date automatically on pasting large amount of date

Hi all

I'm not new to the world of spreadsheets, but very new to the world of VBA. I've only recently started playing around with it to see what it can do.

One of the things that I would like to do is to insert a static date in to a cell when another cell is updated. I have found the following code on these forums and this works well, provided you are updating one cell at a time manually.

Please Login or Register  to view this content.

My requirement is that the cells update after pasting in several lines of data in one go.

I've found other lines of code for checking for a paste event....

Please Login or Register  to view this content.

...but I am unsure if this is the 'correct' method or even if these can be combined and if they can be combined, how to do this!

Any help is greatly appreciated!

Hi Toro,

Welcome to the Forum!

What do you mean by Static Date - is it a previous date?

Originally Posted by Toro-

My requirement is that the cells update after pasting in several lines of data in one go.

Try this. It puts the date(s) in column B when column A is changed.

Please Login or Register  to view this content.

Originally Posted by Toro-

Thanks

By static date I mean one that does not change. To be more specific it would insert the date from NOW() or TODAY() but convert this to a static date/time so that when you reload the seet the following day, the date does not change and when more data is inserted, the new date is put in next to it.




This appears to have done the trick. Many thanks for your assistance

although having said that... if you change the table range it updates the whole date column, including table header