A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Sub Flatten() Dim LastR As Long, LastC As Long Dim arr As Variant Dim RCounter As Long, CCounter As Long Dim DestArr() As Variant Dim DestRow As Long Dim wb As Workbook With ThisWorkbook.Worksheets("Sheet4") 'rename as needed LastR = .Cells(.Rows.Count, "b").End(xlUp).Row LastC = .Cells(1, .Columns.Count).End(xlToLeft).Column arr = .Range(.Cells(1, "b"), .Cells(LastR, LastC)).Value End With ReDim DestArr(1 To (LastR - 1) * (LastC - 2), 1 To 3) As Variant For CCounter = 2 To (LastC - 1) For RCounter = 2 To LastR DestRow = DestRow + 1 DestArr(DestRow, 1) = arr(RCounter, 1) DestArr(DestRow, 2) = arr(1, CCounter) DestArr(DestRow, 3) = arr(RCounter, CCounter) Next Next Set wb = Workbooks.Add [a1:c1] = Array("Module", "User", "Permission") [a2].Resize(UBound(DestArr, 1), UBound(DestArr, 2)).Value = DestArr wb.SaveAs "c:\Test\Foo.xls", xlExcel12 wb.Close End Sub
|Preserve formatting during mail merge using VBA||18||39|
|how to loop through and process two columns in excel||8||17|
|VBA - Transfer values from Master wb to all wbs. Delete old data, copy new data from master wb to user wbs located in a folder.||3||13|
|Excel Formula for Commission Structure||2||12|