1. I am tracking census information in horizontal dynamic ranges on an Input! sheet. The information is being compared among two organizations. Changing the layout is not prudent in this case.
The date is in row Input!3:3 and the values are in row Input!5:5 for organization 1 and Input!32:32 for organization 2. A separate Graphs! sheet contains several line graphs which I would like to automatically populate based on start and end date cells. Start date is located in cell Graphs!C:3 and end date is located in cell Graphs!F:3.
I'm nearly certain this requires some combination of OFFSET, COUNTA and MATCH functions in named ranges.
2. A separate Weekly Comp! sheet needs to sum the previous 7 days (by row) based on an input date from the Input! sheet.
The date is in row Input!3:3 and the values are in row Input!5:5 for organization 1 and Input!32:32 for organization 2. Column A contains labels. the "Date" cell is located in Weekly Comp!C:5.
Thank you for your assistance!!!