[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

Screenshot attached (i tried a higher quality but it didnt work -- kept saying file too large), A4442 being the first todays date on the top left, and I'd like VBA to select from that cell, all the way down to the last row and a specified column (in this case, column G on the very bottom right)

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

I realize since I am using Excel web, I will have to manually add the VBA stuff and upload it as excel web, and then save a local copy and let it do its thing. Thats totally fine

Reposting because I replied to myself and I think having replies caused most folks to skip over it.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: [VBA request] Select first entry of todays date + last row of a column and copy/paste?
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[mvfsullivan]

I posted somewhere else and decided to ditch MrExcel because you failed to recognize my intention via a PM to you. Wow this place

 

[Fluff]

Maybe that's because
a) You didn't make your intentions clear.
b) Because you chose to ignore what I told you.