Could you please help me to write macro that will do this:
through whole workbook (copy value of every 6th cell to first row in next column, then delete nine rows and again copy 6th cell below to newt row in column,...).
Code:
Range("A8").Select
Selection.Cut
Range("B2").Select
ActiveSheet.Paste
Rows("3:11").Select
Selection.Delete Shift:=xlUp
Range("A9").Select
Selection.Cut
Range("B3").Select
ActiveSheet.Paste
Rows("4:4").RowHeight = 14.25
Rows("4:12").Select
Selection.Delete Shift:=xlUp
Range("A10").Select
Selection.Cut
Range("B4").Select
ActiveSheet.Paste
Rows("5:13").Select
Selection.Delete Shift:=xlUp
Range("A11").Select
Selection.Cut
Range("B5").Select
ActiveSheet.Paste
Rows("6:14").Select
Selection.Delete Shift:=xlUp
Range("A12").Select
Selection.Cut
Range("B6").Select
ActiveSheet.Paste
Range("B9").Select
through whole workbook (copy value of every 6th cell to first row in next column, then delete nine rows and again copy 6th cell below to newt row in column,...).