I'm new to Excel VB macros and have a simple problem (I think)
I've got a huge database of a matrix of about 900 X 300.


For a particular row,column, if is an "X", I'd like to copy the header
(top row data of that column) onto another sheet.

1.1 1.2 1.3 1.4 1.5
1 x x
2 x x
3 x x x
4

would create another sheet

1.1 1.2 1.3 1.4 1.5
1 1.1 1.3
2 1.1 1.3
3 1.1 1.2 1.4

Ultimately, I want to capture the data in Word, but I think if I had
the
headers I could do some cutting and pasting to get it.


Any suggestions?
Thanks in advance.

-b