vbanewbie68
Board Regular
- Joined
- Oct 16, 2021
- Messages
- 171
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi
I get the raw data weekly and want to put it into a macro to pop up an inputbox of Date 'last_modified at' column G. So I would like to add the date and this will select the data.
I then copy all selected data and paste it into a new workbook.
VBA Inputbox would be similar to the process stated above, please see the attached. Ideally Greater than would be preferable in the Inputbox.
I have attached some dummy data and the date to enter is 2022-10-27T15:59:29 UTC. This will allow me to select data. I can use any date and that is the opening date for me to choose from. I am not sure how to create an inputbox like the screenshot below and then to create a new workbook for copy and paste?
We get weekly data like the attached image shows, the data amount varies from week to week.
I get the raw data weekly and want to put it into a macro to pop up an inputbox of Date 'last_modified at' column G. So I would like to add the date and this will select the data.
I then copy all selected data and paste it into a new workbook.
VBA Inputbox would be similar to the process stated above, please see the attached. Ideally Greater than would be preferable in the Inputbox.
I have attached some dummy data and the date to enter is 2022-10-27T15:59:29 UTC. This will allow me to select data. I can use any date and that is the opening date for me to choose from. I am not sure how to create an inputbox like the screenshot below and then to create a new workbook for copy and paste?
We get weekly data like the attached image shows, the data amount varies from week to week.