Pivot Range Question
Posted on 2014-11-17
Rob Henson solved a previous question for me relating to the issue of ranges changing when new data is imported into the spreadsheet. The answer was:
I figured I would be able to make a slight change to this when the range is a single column [Wrong]
So experts, please explain how to make a named range in a single column always pick up up all of the data.
And just to clarify I have 3 ranges Bref, Sub and Source which I then refer to in the below formula.
and my problem is that if the total number of rows imported last was say 260 when I import today and there are 320 the ranges do not increase to 320.