34Views2Replies

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

Regard

Darryl

2 Replies

user
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

user
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