Macro to find worksheet and convert formula to value?

Good day

I have a workbook (Attendance Register) with worksheets named for each month of the year. I would like a macro to run the 1st of every month and find the worksheet named for previous month and convert all formulas to their current value. Eg Macro to run the 1st of May and convert the formulas in worksheet April.

Any help will be truly appreciated

Regard

Darryl

bwrussell7 months ago

Any help I would provide would be from me googling things so I'd suggest starting there. Just search "vb excel ..."

DarrylJ10 (author)  bwrussell7 months ago

Thanks for the reply, I've tried googling, vba sites and youtube but so far unsuccessful.

Hope I can resolve this soon.