Write select columns to array & back to another spreadsheet
Hello,
I am trying to take data from select columns in a spreadsheet adn write it
to another spreadsheet. The ciolumns are not aligned in any order, and the
number of rows is unknown from week to week.
For example, I need to take columns: A, B, E, F , j, k, L, copy to array,
and the number of rows is unknown. I then to to spit each column back into
another spreadsheet in a specified column.
I have been reading two books, but it seems they only give examples of
arrays with a known number of rows.
Any help is greatly appreciated. I have been playing with this for days.
Pete
|