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

[Mykull]

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.

[alansidman]

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)

[Mykull]

Thanks Alan. I am new to VBA but I am learning. Thanks again.

[sysss]

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

[Mykull]

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

[sysss]

Hi again,

I have added this to sheet Activate event ...maybe is not the right one, could be workbook.open event... and together with previous one seems work like you want.

Please Login or Register  to view this content.

Regards,
Petr

[Mykull]

WOW – You’re good at this.
Ref: Your first solution: That seems to work and may be all that is needed. What I will do is put in tomorrow’s date and wait until tomorrow and see if it auto moves then. It definitely works when you key in the current date though
Ref: Your second solution: That also seems to work. Please forgive me I am new to this – a Rookie for sure. When you say “together with the previous one” this is what my code now looks like that also seems to work. (also see image). I guess it is correct.
Code 1.0.jpg

Please Login or Register  to view this content.

[sysss]

HI,

well I no an expert at all, my friend, just learning on the go but thanks

What I will do is put in tomorrow’s date and wait until tomorrow and see if it auto moves then
I don't think this will work like that. You need to trigger the event somehow. The picture you shared seems to be OK. Here the event happens when you activate the sheet.
But better I think, would be during workbook open. So try change to this:

This code in the Sheet "Delivered":

Please Login or Register  to view this content.

This code in ThisWorkbook:

Please Login or Register  to view this content.

You can enter tomorrow's date in the spreadsheet, save the file and close it. Change your system date to tomorrow for testing. Open the workbook and rows should be moved to Closed.

Regards,
s.