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
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