Two separate (but related) situation/goals:
(1) Auto-copy data from 1 column to another, even when more data is added;
(2) Make sure it works, even though the new column has merged cells.
Situation (1):
Sheet 1 is a list of names, in Column 1.
Sheet 2 is an empty list, in Column 1.
Let's assume both columns are the same.
<tbody>
</tbody>
How do I define the column in sheet 2, so that it automatically updates from the column in sheet 1?
Situation (2):
The same as above, but the cells in sheet 2 are merged. Let's asume that every cell in sheet 2, consists of 3 merged cells.
How do I define the column in sheet 2, which has merged cells, so that it automatically updates from the column in sheet 1?
(1) Auto-copy data from 1 column to another, even when more data is added;
(2) Make sure it works, even though the new column has merged cells.
Situation (1):
Sheet 1 is a list of names, in Column 1.
Sheet 2 is an empty list, in Column 1.
Let's assume both columns are the same.
| SHEET 1 | SHEET 2 | |
| jack | ||
| bill | ||
| john | ||
| david |
<tbody>
</tbody>
How do I define the column in sheet 2, so that it automatically updates from the column in sheet 1?
Situation (2):
The same as above, but the cells in sheet 2 are merged. Let's asume that every cell in sheet 2, consists of 3 merged cells.
How do I define the column in sheet 2, which has merged cells, so that it automatically updates from the column in sheet 1?
