Greetings -

I need help writing a macro for the below formulas that I type/update on a daily basis.

1) =iferror(vlookup(a2, daily new report,7,0),0) - where the report changes daily
2) =COUNTIF('05-10'!$B$1:$B$5562,"d*total") - where "05-10" changes based on the business day
3) =COUNTIFS('05-10'!$B$1:$B$4931,"D*total",'05-10'!$P$1:$P$4931,0) - where the "05-10" changes based on the business day
4) =VLOOKUP("Grand Total",'05-10'!$B:$N,9,0) - where "05-10" changes based on the business day