Tables not maintaining row relationships

cableTIE

New Member
Joined
Dec 14, 2012
Messages
20
Hello,

I have a worksheet that has four columns of data on it that I've formatted as a table with headers.

The data in the columns comes from two other worksheets:

Col A : <data validation : list from worksheet 1>
Col B : <index(match()) from worksheet 1, based on Col A>
Col C : <data validation : list from worksheet 2>
Col D : <index(match()) from worksheet 2, based on Col C>

Each row is then a "record", i.e. A/B/C/D:1 all relate to each other.

The data populates the table fine, but if I use the table headers to arrange the table data (e.g. sort A->Z), the table seems to rearrange itself randomly - the column selected isn't A->Z and the row contents become mixed. I can't see any logic or pattern to the way the table is being arranged by the filtering - do I have to set up the headers in some way to tell them to affect all columns at the same time?

Any help would be very much appreciated - I'm quite keen not to have excel outwit me (again!)

Thanks :)
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

cableTIE

New Member
Joined
Dec 14, 2012
Messages
20
Hello,

I'm shamelessly bumping this back to the top again - I hadn't realised how many posts went up on this forum in one day!

Any thoughts will be very much appreciated,

Thanks :)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,307
Messages
5,600,869
Members
414,411
Latest member
Snowmanaus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top