2 columns from Sheet B are linked from Sheet1. When I sort Sheet1, by Linker#, it changes the display on Sheet 2. The Unlinked column isn’t tied to anything, so gets out of order with the other items on Sheet 2. Do you know how I can keep the rows in Sheet2 intact? Maybe using another function (other than =).
I’m doing this because I’ll add items to Sheet1 and want it to populate Sheet2, but when I sort by linker# (for my case, it will be date), the rows remain intact.
Thoughts? Thanks for your help. Sample is attached.
Sheet1:
<colgroup><col><col></colgroup><tbody>
</tbody>
Sheet2:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I’m doing this because I’ll add items to Sheet1 and want it to populate Sheet2, but when I sort by linker# (for my case, it will be date), the rows remain intact.
Thoughts? Thanks for your help. Sample is attached.
Sheet1:
LINKERA | LINKER# |
A | 5 |
B | 23 |
C | 3 |
D | 5 |
E | 3 |
F | 7 |
G | 5 |
H | 8 |
I | 90 |
J | 4 |
K | 7 |
L | 5 |
M | 1 |
N | 2 |
O | 54 |
P | 3 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Sheet2:
LINKEDA | UNLINKED | LINKED# |
A | Alpha | 5 |
B | Bravo | 23 |
C | Charlie | 3 |
D | Delta | 5 |
E | Echo | 3 |
F | Foxtrot | 7 |
G | Golf | 5 |
H | Hotel | 8 |
I | 90 | |
J | Juliet | 4 |
K | Kilo | 7 |
L | Lima | 5 |
M | Mama | 1 |
N | November | 2 |
O | Othello | 54 |
P | Papa | 3 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>