Copy,Cut, Paste Row to different sheet when date entered becomes todays date - Please Help

I have three identical worksheets named Sold, Delivered, and Closed
I want rows to automatically copy, cut, and paste from Delivered to Closed – WHEN…
The date that is previously entered in column H becomes “Todays Date”.

This is code I have set on the Sold sheet that works very well for moving rows from Sold to Delivered when the trigger word “Delivered” is selected from a dropdown in column F. I’ve tried altering this code with words like CurrentD, TODAY(), to work to move rows from Delivered to Closed when the date entered in column H becomes today's date with no success.

Please Login or Register  to view this content.

I need a separate code to put on the delivered sheet that will automatically copy, cut, and paste rows from Delivered to Closed sheets – WHEN…
The date that is previously entered in column H becomes “Todays Date”. It should be similar to the above code but with a different trigger = when date interred in column H becomes today's date.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

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, it also maintains VBA formatting.

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



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hello,

this one works for me well:

Please Login or Register  to view this content.

Edit:
Well, I am taking this back.
This works when you manually enter the date... but you meant that you have already date entered (some future) and want to move the row when the date become present... right?


Regards,
sysss

Correct. When the date (already entered many days before) becomes the present date.