Good morning,
I'm trying to program a macro that: 1) extracts a specific sheet from an indexed workbook; 2) converts all of the formula-derived cells into their absolute values; 3) opens up a save-as prompt.

My workbook has index formula to auto-populate multiple spreadsheets. When I try to extract one of the workbooks to save separately (to send out-of-company), the problem is that the index-derived cells stay linked to the original document. I can manually select every formula-derived cell, hit F2 to edit, then F9 to calculate and replace the formula with the value, but that's time consuming. Can I program a macro to do all of that? I tried, but I failed.

The worksheet I'd like to extract is named 'Silliker SARF', or 'FSNS SARF' (two separate workbooks that use the same system and I'll be adding this macro to both).
Cells to convert from formula to value:
F19, I24, J24, K24, L24, B33, D33, I33, J33, K33, L33, I34, J34, K34, L34 and maybe adding more later...which I can do once I see the coding pattern.

Any thoughts?
Thanks to one and all!