Combing TWO worksheets into ONE text file

B

BK

Hi,

I've written an excel spreadsheet for automatic calculation of the
performance of 300 items in 1440 different conditions, array as follows:

C1 C2 C3 . C300
R1 R1C1 R1C2 R1C3 R1C300
R2 R2C1
. .
. .
. .
R1440 R1440C1 R1440C300


As each worksheet has maximum 256 columns, I divided the 300 columns into
two worksheets but, at the end, I have to comine the results of the TWO
worksheets into ONE text file, with the format looks like belows,

R1C1 R1C2 R1C3 ..... R1C300
R2C1 R2C2 R2C3 ..... R2C300
.....
R1440C1 R1440C2 ..... R1440C300

Is there any command that I could use to ask the computer to automatically
combine the results from TWO worksheet into ONE text file such that the
first row the the text files starts from Sheet1 R1C1 to Sheet2 R1C300 then
return to a new row, starts again from Sheet 1 R2C1 to Sheet2
R2C300.....repeats until it reaches R1440C300?

Thank you very much
 

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