Hi Sprogget
You need to use a named range and a bit of code to define the range variably according to the data content within. The actual code varies slightly according to the actual content you want to detect.
Try googling 'create expanding range in Excel'. There are plenty of ideas, including this 'official' one:
How to create a dynamic defined range in an Excel worksheet
Hope this helps
Gadget