Transponse help excel
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/131020575@N05/shares/Di79Y8
Thank you.
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago