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
|
Similar Threads
