Scroll bar

[dankgi]

I am trying to add a scroll bar to a dashboard in my Excell workbook. This seems relatively easy. My question is if I end up adding more colums of data than originally anticipated is there a way to set the scroll bar to automatically catch that extra data. So say I have a scroll bar linked to 50 lines of data. If I end up adding 5 more lines of data to my raw data sheet, do I need to go back into the properties of the scroll bar to adjust it, or is there a way i can set the scroll bar to automatically catch those extra 5 lines of data. Any help would be greatly appreciated. Thanks!