Data Sort

[Nate]

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.

 

[Sheeloo]

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

 

[Shane Devenshire]

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.

 

[Sheeloo]

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]

Hi Sheeloo,

You know Bob Umlas has looked at this subject in detail, maybe he will pop
in on this one.

 

[Nate]

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?