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

Where/what is the database? (Excel only has 256 columns)

Tim

"BCB" wrote in message oups.com...
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

The database is in Excel. I've got 892 rows and IC or
ID columns. There is header information in a few
of the rows and two of the columns. But the rest
of the rows/columns have a "X" which is my data.
Maybe that is part of the problem because I may
have too many columns. I want to capture the
header information for each of the rows so I
can put the information in a real database.
I got a book on this stuff now, so maybe this will
explain so things I'm doing wrong. There is no
way that I'm going to type out all the headers by
hand for each row (activity).