copying sheet to new book

[rhombus4]

I know how to copy a sheet to a new book, however the sheet I want to copy has lots of formulas that relate to that book.

Also it has a few formats as well. I know you can pastee special and just use values but that would lose the other formats.

Maybe a macro could be the answer but not sure

Thanks

 

[rhombus4]

Is it possible to copy the sheet even if it has an IF(indirect formula

 

[rhombus4]

Is it possible to copy the sheet even if it has an IF(indirect formula

Really confused as to why other formulas work but not this one

 

[rhombus4]

Bump