Hello,

I need to create a macro to copy my active sheet and rename the new worksheet with the cell name in R1.

Also I have some data/formulas in the range C9:K396 (name Manager "FORMM") that I wish to copy but only without blank cells.

Is it possible to manage both action in a same macro?

Thanks,
Graig