Linking data between sheets problem

[Britnell]

I have an Excel spreadsheet (Office X, up to date) where I have 6
worksheets. On each sheet, column A are names, and the rest of the
columns either accept data or have formula.

I have linked sheet 2 A1 & sheet 3 A1 and sheet 4 A1 etc, to sheet 1 A1
so that if "Danny" is the value entered in 1 A1, "Danny" shows up in A1
in the other sheets.

The problem is that when I enter a new name on sheet one, I can sort so
that column A is alphabetical, and keep all the data sorted correctly,
BUT on sheet 2 through 6 the names have moved but not the data.

How do I solve this problem? Thanks

 

[Bob Greenblatt]

I have an Excel spreadsheet (Office X, up to date) where I have 6
worksheets. On each sheet, column A are names, and the rest of the
columns either accept data or have formula.

I have linked sheet 2 A1 & sheet 3 A1 and sheet 4 A1 etc, to sheet 1 A1
so that if "Danny" is the value entered in 1 A1, "Danny" shows up in A1
in the other sheets.

The problem is that when I enter a new name on sheet one, I can sort so
that column A is alphabetical, and keep all the data sorted correctly,
BUT on sheet 2 through 6 the names have moved but not the data.

How do I solve this problem? Thanks

It sounds like you have only linked the names and not the other data. A
solution is to sort the other sheets, or link all the rest of the data also.

 

[CyberTaz]

Your problem stems from the fact that the cells in column A of each sheet
are linked by formulas, but the other columns of data are *not* linked from
sheet to sheet - further complicated (it sounds) by the fact that each sheet
is used to track different data pertaining to the same individuals.

I don't know of any facility in XL to sort multiple sheets simultaneously.
Perhaps it can be doe through VBA, but I'm not the guy with that solution

FWIW, I would approach this in a different way. Rather than linking column A
on the various sheets, I would leave them as independent columns/sheets. In
order to add new entries on all three sheets, just click the first sheet
tab, shift+click the last sheet tab, then enter the data in the appropriate
cells of the first sheet. It will 'drill down' through the other selected
sheets.

For sort order each record set would have to be sorted individually, but you
could record a simple macro that would sort each sheet sequentially with the
click of a single button added to your toolbar.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[murtuzamunim]

Hi Bob,

It seems u have linked the absolute reference and not the cell
reference, Just see that there is no $ sign before and after the cell
reference.

for ex: if the link shows xyz$a$1: ( where xyz is sheet reference , and
a1 is cell reference
then u need to put the dollar sign before the cell reference. so your
link should look like xyza1: