Is it possible to mirror or replicate a cell range from one worksheet to another?
For example:
----------------------------------------------
| CELL01 | CELL02 | CELL03 | CELL04 | CELL05 |
----------------------------------------------
----------------------------------------------
| CELL06 | CELL07 | CELL08 | CELL09 | CELL10 |
----------------------------------------------
----------------------------------------------
| CELL11 | CELL12 | CELL13 | CELL14 | CELL15 |
----------------------------------------------
If I wish to copy CELL01
to CELL11
inclusive to another worksheet and have the data update automatically whenever a change is made in the original, how would I go about this?
IMPORTANT: My particular dataset is rather more complex than this and consists of some merged cells, plus cells which are formatted very differently to one another (i.e. alignment, background colours, etc). I am aware of the Paste Link
option, but this isn't exactly what I need; it works to a degree, but encounters problems in areas such as merged cells, for example, entering a 0
into the cells which make up the rest of each merged cell.
Many thanks.