I have a totally messed up spreadsheet coming from multiple mergers of
spreadsheets with basically the same data but different column title
arrangements
My sheet looks like this

A B C D
E F
1 NAME DATE QUEST? ANSWER! =SOLUTION <COMMENT
2 Jan 22/06/05 why? Black! = 3586
< 0
3 Karen 4/10/04 yellow! =ok why not ?
<-
4 Johann red! maybe? <ASAP =pending
31/08/06
5 Stefan green! when? <Now 10/10/05
=325
6 John who? Nobody! 20/10/06 =in prgrss
<impossible
7 Karen yellow! =415 why not? <impossible
3/10/04
8 Cecil =none 01/02/06 grey! =donE
<positive
9 Johann 18/02/04 blue! where? =Positive < n
acceptable
etc€¦.

I want to restore a €œnormal sheet€� with the right data in the right columns
€¦without loosing the horizontal integrity however.
Currently I do this manually with multiple auto filter and then copy past
the data in a new spreadsheet to construct a little excerpt for the business
on hand with a particular person when and if needed. Then I obtain €¦tediously

A B C D E
F
1 NAME DATE QUEST? ANSWER SOLUTION COMMENT
2 Johann 31/08/06 maybe? Red! =Pending <ASAP
3 Johann 18/02/06 where? Blue! =positiv <not
acceptable

It would be handy to do this ones and forever for the entire spreadsheet
with a vba routine if at any possible given the chaos!!!
The only consistency throughout the whole spreadsheet is that
names are kept under NAMES and all the items summed up in the row after
that particular name( say in line 6 for John€¦) has been performed at that
particular date (who appears in E and should be in C6) for that person
€¦.so... should be kept together in the new spreadsheet
If , of course, somebody could write a routine to clean up he entire mess
that would be fantastic; but I would already be happy if I could sort out
automatically a name and date consistently with the rest of the horizontal
rows like this:
A B C D
E F
1 NAME DATE QUEST? ANSWER SOLUTION COMMENT
2 Johann 31/08/06 maybe? <ASAP =pending red!
3 Johann 18/02/04 blue! where? =Positive
< not acceptable

The problem boils down to a date filtering, extracting loop routine in my
opinion ....
To make it even more difficult : the signs: ? < = ! are just used here to
differentiate the nature of the data since this is a hypothetical table €¦in
reality these data are large text strings, or when it comes to the heading
€œ=SOLUTION€� sometimes a number format (this can give some surprises when
trying to extract dates in their number format)so this signs cannot be used
in a filtering vba routine as criteria to handle the restructuring of the
chaos
I hope somebody can help €¦?
Thousand thanks in advance€¦