working on a loop that would run through all 6 sheets in a workbook.
expecting to get Total Stock Value
ws.Cells(SummaryRow, 12).Value = Application.WorksheetFunction.Sum(ws.Range(ws.Cells(i, 7).Offset
(-TotalVolume), 0), (ws.Cells(i, 7)))
working on a loop that would run through all 6 sheets in a workbook.
expecting to get Total Stock Value
ws.Cells(SummaryRow, 12).Value = Application.WorksheetFunction.Sum(ws.Range(ws.Cells(i, 7).Offset
(-TotalVolume), 0), (ws.Cells(i, 7)))
Copyright © 2021 Jogjafile Inc.