Can I keep linked cells between sheets when using tables?

  • Thread starter Thread starter Eric
  • Start date Start date
E

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?
 
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.
 
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

Shane Devenshire said:
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


Eric said:
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?
Click to expand...
Click to expand...
 
Back
Top