That's awesome - thanks Luke - found a work around but am changing it to this as much more efficient.
Work around was to write a second macro that selected the correct range from the whole data table and then pasting that selection onto a separate sheet (always in the same manner) where the...
Hi-
I am making a chart that I would like to pull daily. My data set will increase every day and I'd like to keep all my data. However, for the chart, i'd like my range to only give me the last 30 days worth of data, not the whole set.
Any ideas?
Thanks
Dain