I have a fairly large spreadsheet with sections for each of 15 business units (BU). There is a column for Invoices, Receipts, Plan Sales, and Backlog for each BU, by week. There are three major sections of this worksheet (current week, four-week average, YTD).
Every Monday, I manually go into this workbook and AutoFill the formulas into the row for the prior week for each of these 45 separate sections...needless to say, this is very cumbersome. For instance, this Monday I had to AutoFill cells A200:D200, A250:D250, G200:J200, G250:J250, S325:V325, and S400:V400. Next Monday, I will have to AutoFill rows 201, 251, 326, 401, etc...
Is there a way to create a Macro that will adjust the cells it operates on every week?
Every Monday, I manually go into this workbook and AutoFill the formulas into the row for the prior week for each of these 45 separate sections...needless to say, this is very cumbersome. For instance, this Monday I had to AutoFill cells A200:D200, A250:D250, G200:J200, G250:J250, S325:V325, and S400:V400. Next Monday, I will have to AutoFill rows 201, 251, 326, 401, etc...
Is there a way to create a Macro that will adjust the cells it operates on every week?