65Views2Replies

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

Comments

The forums are retiring in 2021 and are now closed for new topics and comments.
0
bwrussell
bwrussell

4 years ago

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

0
DarrylJ10
DarrylJ10

Answer 4 years ago

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

Hope I can resolve this soon.