I want to create a dynamic named range, as in the spreadsheet attached. I want to create it in a much larger sheet than this.
The issue I have is I have made the dynamic ranges date1 and datesheet which are dynamic based on the start and end dates in A1 and A2. The ranges are then charted.
i have used index for this - the issue with index is if I enter anything in the top row of column c or d (as i will be in the actual sheet), it gives an error
so, the question is, is there a way to do a dynamic named range with custom start and end using something other than index?