id be happy to help,
could you send an example file of what you would like to do?
i have the sheet, so you want someone to put an x in one of the boxes, and you want the column header with an x placed in it and the name which is in column E,N, W, ect.. populated to a new sheet?
well, to set something up like this there is no formula that will make this work based on the way your sheet is set up. It will require a macro.
I can write this macro for you for an additional fee. If you would like.
I would need to know which version of excel you are using so I could make sure it is compatible with your version.
i have not heard back from you. Should I assume you are no longer interested in help with this?