HI there, searched but did no find anything similar to what I am trying to do. I havea workbook where Column A is a listing of dates in ascending older. I have data in cells V1:AH1 and is a vlookup based on todays date that's pulling from another tab with just data.

i'd like to run a macro that looks up the date in column A and if it matches todays date then it would copy the data range in cells V1:AH1 and paste into the same row as the date in Column A.