The number of columns in the following data file shouldn’t change, however, there will be a new row of data added at the bottom every day. For this reason, I can’t manually create a range name that can be used with some Excel formulas such as ‘DSUM’ and perhaps others.
The code I have works...