I have a large database consisting of about 3500 columns and about 110 rows. The first column (starting at B6) contains time values ranging from .01 seconds to 10 secs (which make up the 110 rows). Each column from D to EFR (starting at Row 6) has data corresponding to the time in that row which was entered in column B. And each column refers to a separate case. So essentially I have about 3500 different sets of data (from Column D to EFR) each corresponding to a given fixed set of times (given in column B). I also have the names for each of these 3500 cases stored in the 4th row of each corresponding column (like D4 to EFR4).

What I need is to generate text files- one for each case- wherein I have the time values that were stored in B column, a tab space, and the corresponding data in say, column D. ANd I need to do this for all 3500 columns. I need a separate text file for each of the columns from D to EFR along with the time data from column B which remains a constant. I also need the name of the file to be stored with the text string that is stored in Row 4 of the corresponding column (ie D4-EFR4). All data except the text strings in row 4 are stored as numbers.

For Example: If I have times ranging from .01 sec to 10 sec (the cells only contain the numbers) covering 110 rows in Column B (Starting at B6), and I have, say numbers 1-110 in Column D (starting at D6), and the text string stored in D4 is say, CaseD, I will need it to generate a text file with the name CaseD, having the values of the times of .01 to 10 in the left (one below the other) and the data from Column D (1-110) to each corresponding time's right -after a tab space. Like below:

.01<tabspace>1
.02<tabspace>2
.
.
10<tabspace>110

Appreciate any help that I can get with VB macros.

Regards,
AKshay