Transponse help

[markecb]

Can I speed up this process, not a problem for a couple of people, but if there is 150+ any help is welcome

As you can see in the pictures to get a result on the sheet 2 had to:

1. copy from sheet 1 paste special into new sheet (marked Transpose option)
2. select all cell with data and make degrees to 0
3. double center cells, modify cell to bold, font size etc...
4.repeat all for second person etc etc..

Is there any VBA or Macro to have this prosses automatically as I write data from one sheet to get a result on the sheet 2

https://www.flickr.com/photos/131020.../shares/Di79Y8

Thank you.

[FDibbins]

Hi, welcome to the forum

1. 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.

2. Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites

[markecb]

Hi, welcome to the forum

1. 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.

2. Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites

Thank you FDibbins, excel file is attached and also youtube link

http://youtu.be/BVX7PVmHPYs?hd=1