Luis wants to try rhis in Excel:

Filename1 Filename2 Filename500
101- C 101- I 101- I
102- C 102- C 102- C
103- I 103- C 103- I
104- C 104- I 104- C
105- I 105- C 105- I
... ... ...


I'm sorry Luis,
It seems that you want to have mutiple instances for 1 ID.
This can only be done if you less than 65000 records and less then 255
columns.
But even if you would use all possible cells in your Worksheet, Excel will
crash down.

You need to change to Access or another database-application that can handle
1-to-many relationships.

Your question is beyond Excel's possibillities.

Have a look at the newsgroup: microsoft.public.access

Excel is a smart program, but there are limits.

I wish you all the best in convincing your chef/boss/etc that you need to
widen your scope to not just handling a single table database in Excel but
handling relational databases, with many tables that are linked to
eachother.

good luck,

sybolt