Replace all non blanks in a column with column header

G

Guest

I think I need a macro to do this, but I can't figure out how to write this
macro. I am using excel 2003. My first row contains what I consider to be
column headers. I'd like to search through each column in a worksheet and
replace any x in the column with the column header. The following is an
example:

col1 col2 col3 col4 col5
row1
row2 x
row3 x

I would like the "x" in row2 replaced with "col2" and the x in row 3 with
"col4"

Frankly, I have no clue where even to begin on this one. I appreciate any
help anyone can provide.

Thanks,
Holly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First non blank number in a row 4
Header of column which has minimum in row? 1
Conditional Formatting HELP 2
Total values per colour 7
Comparing and populating data between 2 sheets 1
How can I find the row nr of the first number lower/ higher then a 3
Matching and Moving Data From One Spreadsheet to Another? 1
Excel 2007 - Pivot Table Report Values fields 1

Top