Hello I recently have started a new job that requires me to use a lot of excel for my day-to-day.. I've learned so much, and I'm starting to watch videos and learn even more than I could imagine. I'm stuck though on an issue I would like to be able to automate.
I have this daily report.. It has columns with the day of the month and the date
and then it has on Column A a Task List.
<tbody>
</tbody>
I would like to learn how to do two things with it. Learning will help me reproduce similar and better results for other projects too.
I would like to open the worksheet and it run a macro that says: TODAYS DATE (Example: Today is the 5th), Grab the 5th Date column, and pull all of the rows that have a task that has stop in it, paste it into another sheet, like this:
<tbody>
</tbody>
And also I would like to be able to have a macro that pulls the current month and resets the top Day and Date columns to what those would be.
So January 1 I could open it and run the macro and the 1st column would be TUES, 1st and it would update that entire row.
Further down the road, i know certain tasks are due certain days every month. So TRAIN would always be STOP on the 5th, 10th, 15th, etc.
How could I place the values once it updates the header dates?
Sorry for the loaded question.. I'm eager to learn and thanks for any tips or resources you can provide.
I have this daily report.. It has columns with the day of the month and the date
and then it has on Column A a Task List.
SUN | MON | TUE | WED | THURS | |
TASK | 1st | 2nd | 3rd | 4th | 5th |
WORK | W | STOP | W | W | W |
AUDIT | STOP | SDO | STOP | W | SDO |
TRAIN | SDO | SDO | STOP | W | STOP |
OTHER | STOp | STOP | W | SDO | STOP |
<tbody>
</tbody>
I would like to learn how to do two things with it. Learning will help me reproduce similar and better results for other projects too.
I would like to open the worksheet and it run a macro that says: TODAYS DATE (Example: Today is the 5th), Grab the 5th Date column, and pull all of the rows that have a task that has stop in it, paste it into another sheet, like this:
TASK | 5th |
TRAIN | STOP |
OTHER | STOP |
<tbody>
</tbody>
And also I would like to be able to have a macro that pulls the current month and resets the top Day and Date columns to what those would be.
So January 1 I could open it and run the macro and the 1st column would be TUES, 1st and it would update that entire row.
Further down the road, i know certain tasks are due certain days every month. So TRAIN would always be STOP on the 5th, 10th, 15th, etc.
How could I place the values once it updates the header dates?
Sorry for the loaded question.. I'm eager to learn and thanks for any tips or resources you can provide.