Macro to find worksheet and convert formula to value?
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