Macro identifying tomorrow column as "today", then filling Thursday's column

Attached Code should find the column on the MASTER sheet dated today (Col T) and fill each cell where the file number in Col D matches a file in Col D of the TODAY sheet.

It's picking up the correct row, but then identifies "today" as Column U (tomorrow's date), but then "filling" Column X, which is Thursday!

Please Login or Register  to view this content.

No idea why, so all suggestions, recommendations and alternatives welcome as ever.

Ochimus

You are using a match to see where is the column with the right date.
Use a FIND statement as you did for the file name

There is some sloppy references in your code..

this is the entire code, the blue code lines have changed and 1 line above (select statement) was removed

Please Login or Register  to view this content.

in the Clng(Cdate(Now))-part Now is not only a date but also a time, the value of NOW is f.e. 43198,75 this was rounded up to 43199
by using the vba command "Date" you only get wholenumbers like 43198, so no rounding errors

the outcome of y is colomn 20 for april 8. but that is counting from column A.
by using .Cells it moves 20 columns to the left from the starting position.
You set the starting position to column D at the beginning of the first With statment
( With Sheets("MASTER").Range("D:D") 'searches all of column D)
So for the second with statement you need to "reset" the starting point to column A
also deleted the select and selection which is obsolete in (almost) any code.

By changing those 2 lines, it will work:

Please Login or Register  to view this content.

You may use

Please Login or Register  to view this content.