Sorting a table used as a reference in another table

jburdge

New Member
Joined
Jun 6, 2013
Messages
1
I have two tables. The first table contains data which is referred to by a second table. I would like to sort the first table; however, when I do the references do not "follow" the data in the second table. Is there a way to do this, so that when I sort the first table the references in the second table change as well?
Thanks so very much!

JOrdan
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,095,395
Messages
5,444,228
Members
405,275
Latest member
RefreshSQL

This Week's Hot Topics

Top