If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
linking within a workbook and sorting
I have an issue whereby I have linked cell in Sheet 2 that's linked to Sheet
1. When the sheet1 area sorts, my cell in Sheet 2 looses the data I want to capture. sheet1 below has this list, cell C4 has range name 'detail3' A B C line details number 4 detail 4 103 3 detail 3 102 2 detail 2 100 1 detail 1 99 In Sheet 2.C3 there is a link to Sheet1.C4. When I sort Sheet1 list my Sheet 2 doesn't capture the data I want. -- bmac |
#2
|
|||
|
|||
linking within a workbook and sorting
Use range names. If you name Sheet1!C4, then use the range name in
Sheet2!C3 when referring to the cell on sheet 1, you can resort Sheet 1 and preserve the reference. --JP On Oct 8, 9:09*am, bmac wrote: I have an issue whereby I have linked cell in Sheet 2 that's linked to Sheet 1. When the sheet1 area sorts, my cell in Sheet 2 looses the data I want to capture. sheet1 below has this list, cell C4 has range name 'detail3' A * * * * * * * * B * * * * * * C line * *details number 4 * * * detail 4 * * * *103 3 * * * detail 3 * * * *102 2 * * * detail 2 * * * *100 1 * * * detail 1 * * * *99 In Sheet 2.C3 there is a link to Sheet1.C4. * When I sort Sheet1 list my Sheet 2 doesn't capture the data I want. |
#3
|
|||
|
|||
linking within a workbook and sorting
Hi JP
thanks for responding, however something is not working. In Sheet1. c4 I gave the range name. I went to Sheet2 and entered =nameLine2 I went back to Sheet1 and resorted the data.. Sheet2 kept the location, but the cell I want to keep was sorted at the bottom.. I want to be able to link a Sheet1 cell (contents being 101), in a Sheet 2 cell, that has =namelink2 - wherever that Sheet1 cell moves - I want my Sheet2 cell to still be that results, contents being 101. -- bmac "JP" wrote: Use range names. If you name Sheet1!C4, then use the range name in Sheet2!C3 when referring to the cell on sheet 1, you can resort Sheet 1 and preserve the reference. --JP On Oct 8, 9:09 am, bmac wrote: I have an issue whereby I have linked cell in Sheet 2 that's linked to Sheet 1. When the sheet1 area sorts, my cell in Sheet 2 looses the data I want to capture. sheet1 below has this list, cell C4 has range name 'detail3' A B C line details number 4 detail 4 103 3 detail 3 102 2 detail 2 100 1 detail 1 99 In Sheet 2.C3 there is a link to Sheet1.C4. When I sort Sheet1 list my Sheet 2 doesn't capture the data I want. |
Thread Tools | |
Display Modes | |
|
|