Hi,

I have a problem with a large data file, and I'd like to get some help. I
believe I require an array to be able to separate the data the way I want it,
however, I'm not quite sure on how to go about it.

The way the data is set ip is like this;

Column A - Date and hour (data comes in every hour)
Column's B-F Hard or Soft (rows could be all hard, or all soft, or any
combination of the 2 words)
Columns G-AL Data points referring to columns B-F. ie
Link column B(row) to range G(row)-M(row)
link column C(row) to range N(row)-R(row)
link column D(row) to range S(row)-X(row)
link column E(row) to range Y(row)-AD(row)
link column F(row) to range AE(row)-AL(row)

What I need is to take column A (date-time), verify columns b-f to see if
they are hard or soft, and transfer the linked data to sheet hard or sheet
soft.....
example 12/04/08 11:00 hard hard soft soft hard (data points from column G
to column AL) i would transfer column a to both hard and soft sheets (i need
the date and time) and transfer ranges G-M, N-R and AE-AL to the hard sheet
and the ranges S-X and Y-AD to the soft sheet on the same line. Having to go
through over 12000 lines of data in this way is just too difficult for me at
the moment. Thank you for any help that can be offered.

Allan