Hello,
yes, range Zero is column S, row 6 to 8. This range expands to all the lines of the report after the report runs in our financial system, thus the range on my test report becomes S6 to S1121. I can see this by looking at the named range before (S6..S8) and after the report runs (S6..S1211). The last row will change week by week depending on how much data is on the report.
I have seen coding for the bottom up delete but am not sure how to incorporate it into my macro since I am using a range. See my updated macro below.
Is it easier to use cells or just the column? The row totals will always be in column S, could I use a cell reference like S6..S2000. (many more cells than needed).
Bookmarks