Can I keep linked cells between sheets when using tables?

[Eric]

Can I keep linked cells between sheets when using tables and sorting of those
tables?

For example, when I reference a cell that is in a table in "Sheet1" to
"Sheet2" and then I sort the table in "Sheet1" I will lose the link in
"Sheet2". Is there a way to keep these links when sorting tables even though
the referenced cells change the number position in the sheet?

 

[Shane Devenshire]

Hi,

Have you tried? I have no problem keeping the links. If you are using
tables the formulas, if you create them by pointing and clicking look like

=Table2[[#This Row],[Country]]

You must link the title row separately but the other row and column formulas
can be copied and pasted.

 

[Ashish Mathur]

Hi,

I do not see any formula like this. When I convert a range to a table
(Ctrl+T), and when I lick to any cell in the range, the cell only shows the
link and nothing like what you show below. What am I missing?

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

Hi,

Have you tried? I have no problem keeping the links. If you are using
tables the formulas, if you create them by pointing and clicking look like

=Table2[[#This Row],[Country]]

You must link the title row separately but the other row and column
formulas
can be copied and pasted.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

Can I keep linked cells between sheets when using tables and sorting of
those
tables?

For example, when I reference a cell that is in a table in "Sheet1" to
"Sheet2" and then I sort the table in "Sheet1" I will lose the link in
"Sheet2". Is there a way to keep these links when sorting tables even
though
the referenced cells change the number position in the sheet?