Hello,

I insert my rows at the bottom of my data set. Below that are all the calculations, mostly sum or sumproduct functions. Each time I have to manually expand the selection to capture the new rows. Is there a way for Excel to pickup the expanded data set automatically?

Thanks,
Max