PDA

View Full Version : Macro - transpose - audit



coltaalex
05-23-2012, 10:00 AM
Hello experts in VBA excel.

I have a excel sheet, with which my coworker collects data from the different audits, he is collecting it on diagonal form (upper left to bottom right), because the columns and rows content is changing all the time ( data collection)

So i would like to create a macro which is transposing the row information into column, and from diagonal to make a column.
I attached and excel workbook, with two sheets :
1.one is called audit input ( collection of the data)
2. and the Transposed sheet, where i want my data to be transposed.

CatDaddy
05-23-2012, 11:13 AM
http://www.ozgrid.com/VBA/transpose-rows.htm

coltaalex
05-23-2012, 11:21 AM
I'm not good in programing but i will try, thank you :think: