VBA to move column headers to rows

Hello All,

This is my very first VBA and I am learning on-the-go here. I am trying to put a excel which is in the following format. (attachment 1)
Sheet1.pdf



I am trying to write something a macro/function that starts reading from Row1, column 1, and if the cell has "T" it writes the value and functionid to another sheet. So it looks like this:
Sheet2.pdf

This is whT I have, but it is not working as expected for me. I want to use index, and many other things - but right now even copy paste, is not working.

Can anyone help me understand, how I can copy the cells for a match as we process every cell.

VBA.pdf

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

Also, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

I will try to post your code...


hmm nope, I cannot post it either, I will ask the TT why not

It's not accepting "select..." for some (sql) reason today: --> (Xelect...)

Please Login or Register  to view this content.