Can three separate sections of rows be sorted in the same order?
 

I have an Excel worksheet that is divided into three sections:

1st section: The percentage of people who responded a certain way.
2nd section: The difference between how people responded in previous surveys
and the current responses to each question
3rd section: The statistical margin of error for each year of responses to
each question.

The columns are set up like this:

Column A: Symbol used on chart
Column B: Question text that data refers to
Column C-ZZ: Data for each year the question is answered

The three sections are set up the same way, but, with the exception of the
symbol for the chart and the question text, the numerical data for each
question in each section is different.

Having said all that; is there a way to sort the other two sections of data
to mimic the first? Currently sorting them separately produces questions
that are not in the same order as those in the first section. I hope this
isn't too much info, but I sure hope there's a way to do this.

Thanks for any help.

Can three separate sections of rows be sorted in the same order?
 

Nevermind. I figured out what I was doing wrong!

"Jacquiemal" wrote:

I have an Excel worksheet that is divided into three sections:

1st section: The percentage of people who responded a certain way.
2nd section: The difference between how people responded in previous surveys
and the current responses to each question
3rd section: The statistical margin of error for each year of responses to
each question.

The columns are set up like this:

Column A: Symbol used on chart
Column B: Question text that data refers to
Column C-ZZ: Data for each year the question is answered

The three sections are set up the same way, but, with the exception of the
symbol for the chart and the question text, the numerical data for each
question in each section is different.

Having said all that; is there a way to sort the other two sections of data
to mimic the first? Currently sorting them separately produces questions
that are not in the same order as those in the first section. I hope this
isn't too much info, but I sure hope there's a way to do this.

Thanks for any help.