Hi,

I am looking for a macro. I have 20 sheets in a work book, and i want to cut the cells with range C10:H200 which are having formulas with dependent and precedent cells, and smartly paste the cells in column AD10:AH200 (so that dependent and precedent cells get updated with change in cell, and formulas get updated). now similarly, i want to unhide the columns from w to AD and cut the cells W10:AB200 which are having formulas with dependent and precedent cells, and smartly paste the cells in column and smartly paste it in C10:H200 (so that dependent and precedent cells get updated with change in cell, and formulas get updated). At the end i want to hide the columns from S to AM gets hide.

Like this i have 25 workbooks.

Please help me out from this. Thanks.