How to lock formulas in multiple cells and then copy them to a range of cells?

[Arinoum]

I have several cells with a formula that I would like to copy but when I copy them they move the formula range. I would like to lock it with a $ but I have 365 cells (number of days) to lock then copy over to the next tab. How can I select all cells and Lock them with c$2 automatically without having to manually do it for each day then copy it over?

 

[Muhammad_Usman]

Check out post #6 here: Cementing Formulas

 

[Arinoum]

Check out post #6 here: Cementing Formulas

Thank you so very much!