Sorting linked worksheets when there are unlinked cells in a row

[texacali]

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:
[TABLE="width: 148"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]LINKERA[/TD]
[TD]LINKER#[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]I[/TD]
[TD="align: right"]90[/TD]
[/TR]
[TR]
[TD]J[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]K[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]N[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]O[/TD]
[TD="align: right"]54[/TD]
[/TR]
[TR]
[TD]P
[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]


Sheet2:
[TABLE="width: 201"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]LINKEDA[/TD]
[TD]UNLINKED[/TD]
[TD]LINKED#[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Alpha[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Bravo[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Charlie[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Delta[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]Echo[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]Foxtrot[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD]Golf[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD]Hotel[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]I[/TD]
[TD][/TD]
[TD="align: right"]90[/TD]
[/TR]
[TR]
[TD]J[/TD]
[TD]Juliet[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]K[/TD]
[TD]Kilo[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD]Lima[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD]Mama[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]N[/TD]
[TD]November[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]O[/TD]
[TD]Othello[/TD]
[TD="align: right"]54[/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]Papa[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[ca.moazzam]

Hi when you link a cell to any other cell, it links the cell address (for example cell A3) and not the value in cell A3. If you need to do any modification in the source data later on which will change the values in the source cells, you should use some formula. In your case the simplest formula is VLOOKUP. You can understand it using office help.

If I copy the above data including headings in to 2 different sheets starting cell A1, the formula in cell C2 of Sheet2 would be: =VLOOKUP(A2,Sheet1!$A$1:$B$17,2,FALSE). This will give you the desired value (5) in cell C2. After applying this formula to all desired cells in Sheet2, you can sort the source data. The reults would remain unchanged.

Moazzam