When I try to copy some data in-between the cells or a range shifting cells down; the inserted cells or data loses its formatting and formula? Can it be avoided?
Hi @Emoh
please, can you edit your question to specify step by step how you proceed to copy and shift ?
Regards