Hello, I have a reference to a range of cells on a seperate sheet, these are in the same document.
Is there a way to copy the formatting of the referenced sheets automatically? I’m currently getting frustrated as when i add a new line to the area being referenced it breaks my layout in the first sheet.
What i want to be able to copy is the data which works but also the borders, font styles and merged cells.
Is this at all possible? or would i need a macro to do it?