Fill the formula from start to end of week nos excel vba

Dear Experts

I have formula in particular multiple cell range i want fill cells to column wise till where weeknos ends,

from H22:H37 some formula in the cells..once click the cmd button it has to fill till end of weekno in header row start from h21 to till XDF21..
if i click clear button all formula will clear apart from H22:H37.... apply loop to all yellow colored sheets except(RAWDATA,CDS)

Find the attachment

Please Login or Register  to view this content.

Thanks sir it works perfectly... 100% reputation solved

Glad to hear it!