classifying non adjacent lines and columns

[socram_06]

Hi there... Hope you are fine !!!

Is there any way to classify data following this: (???)

I type...
n C5: Mary
result: C5: Mary
in C9: John
result: C5: John..... C9: Mary
in C13: Anne
result: C5: Anne.... C9: John.... C13: Mary

and so on til line 41... Ten names automatically classified while I type. I need three blank lines between the typed names, and when I'm in the last one (line 41), I'll put other ten names, this time in column E (I can not use the column D), but I need the classification still be active... So, if in E5 I type "Alan", the result now must be:

C5: Alan.... C9: Anne.... C13: John............................E5: Mary

Is it possible ??? How ????

In advance, tanks for help !!

Marcos.

[socram_06]

any idea ????

using this code....

Please Login or Register  to view this content.

... I can do the classification along the 5th line, starting in column C, but how coul'd I modify it to "read" every four column, classifing them ???

Very thanks...
Marcos.