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 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago