| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking cells together when sorting | Excel Discussion (Misc queries) | |||
| Linking then sorting | New Users to Excel | |||
| workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
| Linking Master Workbook & subordinate workbook | Excel Discussion (Misc queries) | |||
| Linking messed up when Sorting | Excel Discussion (Misc queries) | |||
Threaded Mode
