8/30/2023 0 Comments Pivot table addons for mac excelSet rRes = rRes.Resize(rowsize:=UBound(vRes, 1) + 1, columnsize:=UBound(vRes, 2)) Cells(LastRow, LastCol))įor I = 2 To UBound(vSrc, 1) 'Skip the first row 'Set Source and Results Worksheets and Ranges Class Moduleĭim wsSrc As Worksheet, wsRes As Worksheet, rRes As Rangeĭim I As Long, J As Long, LineCount As Long You can certainly adjust that to pretty things up, if you need to. There is also an area near the end of the regular module where I do some rudimentary formatting. Note that you have to rename the class module as noted in that module.Īlso note that you may have to rename wsSrc and wsRes - the worksheets with your source data and where you want the results to go. Here is a VBA method that should work quite rapidly, even on a large data base.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |