[VBA request] How do I find the first cell containing todays date and copy that cell to the last row and a specific column?

[mvfsullivan]

How do I identify and select the first entry containing todays date, and then identify and select the last row and specific column and copy it to clipboard + paste it into a different worksheet and cell?

I have an Excel web file with 3 work sheets. I save this file locally and edit from there each day (excel web so it works with PowerAutomate)
- Sheet 1 is a stats table containing info for the present day
- Sheet 2 is a table that auto fills based on user reported issues (I run a server)
- Sheet 3 is a series of tables that I use to manually paste todays info into a cell and VBA/formulas basically do the rest and fill out sheet 1 for me
- I then take a screenshot and blank everything out for the next day

Example of some of the rows ( a - represents the next column, sorry I dont have the file on me right now):
Ideally I'd like VBA to detect and select cell A4023 to D4025 in sheet 2, and paste it into B306 in sheet 3.

A4022: 12/27/21 - 1:00 PM - App crashed - Restart app
A4023:12/28/21 - 12:30 PM - Server down - Restart server
A4024: 12/26/21 - 1:30 PM - App crashed - It took me a few days to fix it
A4025: 12/28/21 - 12:30 PM - Server down - Restart server ( <- this "restart server" would technically be for example, D4025)

Thank you to all of you Excel masters helping random folks like me, I am so shocked by how quickly you guys get to questions all day, its literally insane lol. Doing gods work :D

 

[mvfsullivan]

One thing I forgot to mention, for the time being, I have two separate files, one is Excel web with no VBA because it doesnt exist there, the other is a local copy which I converted into a VBA-capable file. I dont think its possible to even do what I'm asking now that I think about it because how would I even configure VBA when it doesnt exist. I'd have to import or something which sort of eliminates the ease of use? Any suggestions?

 

[mvfsullivan]

OHH I just realized if I were to upload a Macro enabled workbook I could then have PA do its thing and then run vba in the local copy. I didnt realize you could do this, nice :D

 

[Fluff]

Duplicate to: [VBA request] How do I find the first cell containing todays date and copy that cell to the last row and a specific column?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.