| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Sort
If I have linked cells in other tabs to my data field and I want to sort my
data field, how do I sort so that my linked cells in other tabs stay linked to the specific data I originally chose. -- Nate |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Sort
Instead of linking to others sheets like
=Sheet1!A1 link using INDIRECT =INDIREC("Sheet1!A1") Even after sorting they will point to the original cell "Nate" wrote: If I have linked cells in other tabs to my data field and I want to sort my data field, how do I sort so that my linked cells in other tabs stay linked to the specific data I originally chose. -- Nate |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Sort
Thanks Sheeloo. I currently have multiple tabs linked in the way I originally
described. Is there a way to easily update all the tabs to this new "INDIRECT" formula? -- Nate "Sheeloo" wrote: Instead of linking to others sheets like =Sheet1!A1 link using INDIRECT =INDIREC("Sheet1!A1") Even after sorting they will point to the original cell "Nate" wrote: If I have linked cells in other tabs to my data field and I want to sort my data field, how do I sort so that my linked cells in other tabs stay linked to the specific data I originally chose. -- Nate |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Sort
Hi,
Unless I missunderstand the use of INDIRECT does not do what you need. You should test it with a few cells before you spend the time modifying all the cells. If I understand, you want to sort raw data and other sheets that are linked to that raw data you want to refer to the new location of the data after the sort? This is not going to happen with this approach. Show us a sample of your data and we might be able to provide a solution. Show us the raw data layout and what you want the linked data layout to look like before and after sorting. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Nate" wrote: If I have linked cells in other tabs to my data field and I want to sort my data field, how do I sort so that my linked cells in other tabs stay linked to the specific data I originally chose. -- Nate |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Sort
Shane is right... My suggestion would work only if you sort the cells
containing the INDIRECT formula... So do test before making big changes... Let us agree on what you want before trying to find an easier way to do it. "Shane Devenshire" wrote: Hi, Unless I missunderstand the use of INDIRECT does not do what you need. You should test it with a few cells before you spend the time modifying all the cells. If I understand, you want to sort raw data and other sheets that are linked to that raw data you want to refer to the new location of the data after the sort? This is not going to happen with this approach. Show us a sample of your data and we might be able to provide a solution. Show us the raw data layout and what you want the linked data layout to look like before and after sorting. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Nate" wrote: If I have linked cells in other tabs to my data field and I want to sort my data field, how do I sort so that my linked cells in other tabs stay linked to the specific data I originally chose. -- Nate |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Sort
Hi Sheeloo,
You know Bob Umlas has looked at this subject in detail, maybe he will pop in on this one. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sheeloo" wrote: Shane is right... My suggestion would work only if you sort the cells containing the INDIRECT formula... So do test before making big changes... Let us agree on what you want before trying to find an easier way to do it. "Shane Devenshire" wrote: Hi, Unless I missunderstand the use of INDIRECT does not do what you need. You should test it with a few cells before you spend the time modifying all the cells. If I understand, you want to sort raw data and other sheets that are linked to that raw data you want to refer to the new location of the data after the sort? This is not going to happen with this approach. Show us a sample of your data and we might be able to provide a solution. Show us the raw data layout and what you want the linked data layout to look like before and after sorting. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Nate" wrote: If I have linked cells in other tabs to my data field and I want to sort my data field, how do I sort so that my linked cells in other tabs stay linked to the specific data I originally chose. -- Nate |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Sort
Hello Everyone thanks for answering.
Heres the info. Tab 1 Labeled "Part # data" 1 Vendor PN MAS PN MAS Description 2 3 KRDM772SGS 22-11683 Shimano XT M772 RD Long Cage 4 KFDM660M6 21-11966 Shimano SLX M660 FD 34.9 5 KSLM590LB 37- Shimano Deore M590 SL Left Front 6 KSLM590RA 37- Shimano Deore M590 SL Right Rear 7 00.5015.082.080 14- Avid 07 Juicy 3 Direct LF 160mm Tab 2 with the following formulas SUPPLIER PART # MAS # VENDOR DESCRIPTION ='Part # data'!B3 ='Part # data'!C3 ='Part # data'!D3 ='Part # data'!B4 ='Part # data'!C4 ='Part # data'!D4 ='Part # data'!B5 ='Part # data'!C5 ='Part # data'!D5 ='Part # data'!B6 ='Part # data'!C6 ='Part # data'!D6 So if I sort tab 1, tab 2 updates with the new info that has been sorted into specific cells. I'd like to keep tab 2 so that it spits out the same info as prior to the sort. Also after the fact I'd like to then be able to update the data in tab 1 and have the links in tab 2 automatically udate. Is there a simple formula I can use? -- Nate "Shane Devenshire" wrote: Hi Sheeloo, You know Bob Umlas has looked at this subject in detail, maybe he will pop in on this one. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sheeloo" wrote: Shane is right... My suggestion would work only if you sort the cells containing the INDIRECT formula... So do test before making big changes... Let us agree on what you want before trying to find an easier way to do it. "Shane Devenshire" wrote: Hi, Unless I missunderstand the use of INDIRECT does not do what you need. You should test it with a few cells before you spend the time modifying all the cells. If I understand, you want to sort raw data and other sheets that are linked to that raw data you want to refer to the new location of the data after the sort? This is not going to happen with this approach. Show us a sample of your data and we might be able to provide a solution. Show us the raw data layout and what you want the linked data layout to look like before and after sorting. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Nate" wrote: If I have linked cells in other tabs to my data field and I want to sort my data field, how do I sort so that my linked cells in other tabs stay linked to the specific data I originally chose. -- Nate |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
| I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
| How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
Hybrid Mode
