sorting column order

B

Brotherwarren

Hi folks,

I'm sure the answer to this must be posted somewhere on this group but
I can't find it!

I have a set of data containing exam results from pupils. The pupils'
names are given in column A,
then for each test that they complete there are 5 pieces of
information, starting with the date the test was taken in column B,
then the test score C, grade this gets in D and two other things in E
and F.

Column G contains the date of the next test that the pupils took,
followed by the test score and so on, repeating this pattern for about
8 tests in total.

I'd like to sort these columns so that each block of 5 columns appears
order, sorted by the date that the pupils took the test.

Is there a way of sorting column order by the values of the cells in
those columns, and is it possible to extend this to sort blocks of 5
columns by the values in the first column in each block of 5?

Many thanks for any advice!

TW
 
O

Otto Moehrbach

TW
There is no built-in way to do this. However, it can be done with VBA.
I'll write the code for you but I will need some details about the
configuration of your data.
In what row is the first name?
Do you have any blank rows in the data?
Are there entries of any type below the last name cell in Column A?
Am I correct that you don't want to change the layout of the test data, you
only want to place the individual tests and associated data in order, by
date, in the same row? Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top