Hello!
I have a summary sheet where I need to have a cumulative total running by weeks.
The VBA I have to extract the weekly data from it's weekly sheet is below, which is working.
However, I need a way to add the prior week's information to the new week. As a cell reference (because someone might change the information for the previous weeks).
Worksheets("Summary").Activate
Dim LastRow As Long
LastRow = Range("A" & Rows.Count).End(xlUp).Row
Cells(LastRow + 1, 1).Value = Worksheets(2).Name
Cells(LastRow + 1, 2).Formula = "=(" & Worksheets(2).Name & "!C18)"
From the below, RS Wall in Week_2 should actually be 8,690.
I have a summary sheet where I need to have a cumulative total running by weeks.
The VBA I have to extract the weekly data from it's weekly sheet is below, which is working.
However, I need a way to add the prior week's information to the new week. As a cell reference (because someone might change the information for the previous weeks).
Worksheets("Summary").Activate
Dim LastRow As Long
LastRow = Range("A" & Rows.Count).End(xlUp).Row
Cells(LastRow + 1, 1).Value = Worksheets(2).Name
Cells(LastRow + 1, 2).Formula = "=(" & Worksheets(2).Name & "!C18)"
From the below, RS Wall in Week_2 should actually be 8,690.