I want a way to complete a dashboard with the month current month’s data, without having to change the cell each month. For example, I have a the following horizontal range:
and I want a cell on a different page to show the current month’s data and the YTD total. Is there any way I can look for the last column greater than zero? If I was doing this in Access I might be able to use the “Last” function.