mvfsullivan
New Member
- Joined
- Dec 24, 2021
- Messages
- 9
- Office Version
- 2021
- Platform
- Windows
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.
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.