Hi

This is my first post - so thanks in advance for any help.


I have a sheet which I update every week, its fuel information from HGV vehicles. Every week I add a new worksheet - named week number - for example WK26. I then have a summary sheet which summarizes the data. From that I then have some line charts.
All pretty basic.

What I want to do is have the charts automatically pick up the new week number and plot it. I hide the previous week on the summary chart so I only ever show 6 weeks of data.

I have read up on dynamic ranges but can only find them to solve vertical data. I have week numbers going across the top and add a new week each week and then the different data going down, distance, litres used, mpg ect.

What I want is for excel to look at columns, A:AZ for example but only show me data for the cells which have values.

Thanks,