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.
[TABLE="width: 200"]
<tbody>[TR]
[TD]SHEET 1[/TD]
[TD][/TD]
[TD]SHEET 2[/TD]
[/TR]
[TR]
[TD]jack[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]david[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 200"]
<tbody>[TR]
[TD]SHEET 1[/TD]
[TD][/TD]
[TD]SHEET 2[/TD]
[/TR]
[TR]
[TD]jack[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]david[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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?