Author Options:

Macro to find worksheet and convert formula to value? Answered

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



2 Replies

bwrussell (author)2017-04-11

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

Select as Best AnswerUndo Best Answer

DarrylJ10 (author)bwrussell2017-04-11

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

Hope I can resolve this soon.

Select as Best AnswerUndo Best Answer