i have 8 columns each having data corresponding to the row its in. I need to sort a column and have all the corresponding data follow. i do not do macros so if it is possible to do with excel functions that would be great. also this must be automatic because my data is updated frequently and i cannot manually sort every time. thank you in advance.