Automatic update date/time

Hey!

I had this VBA code working until i put a formula in in J15 in the "Data" workbook.

Please Login or Register  to view this content.

My plan is to paste the data from A1 in "hej.xlsm" to J15 in "Data.xlsm" based on current date. And in K18 in "Data.xlsm" i want to see when the value in the J15 cell was last changed or updated. As i mentioned, as soon as a formula changes the cells value it stopped working.'

Any ideas?

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Thread moved to VBA section.

Hey!

I've uploaded two examples.

I had this VBA code working until i put a formula in in J15 in the "Data" workbook.

Please Login or Register  to view this content.

My plan is to paste the data from A1 in "hej.xlsm" to J15 in "Data.xlsm" based on current date. And in K18 in "Data.xlsm" i want to see when the value in the J15 cell was last changed or updated. As i mentioned, as soon as a formula changes the cells value it stopped working.'

Any ideas?

I am still waiting for you to add code tags - this needs doing in both posts, please. There will be no help offered until you have done this, sorry.