Automating & Learning

[firef0x]

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.

	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.

 

[My Aswer Is This]

From this image I assume task is in column A

And do you want the entire row copied to another sheet or just column A and todays column.

And please never say "another sheet"

We need sheet names.

What is the name of the sheet with your data
What is the name of the sheet where you want this data copied to?
Or do you want the script to create a new sheet. And if so what would the new sheet be named?

See we always need specific details like this.

And I assume the Days like Mon are in Row(1) is that correct?

And why no Friday or Saturday

 

[My Aswer Is This]

I also think row(1) columns should have dates in them like 1/7/2018
That way it's easier to fine proper column
If not you will have to reset this every 7 days because the script would not know what column to look for if you had Mon in several different columns in row(1)