Based on this post: www.annielytics.... Want to add a table to your dashboard but not take up too much space? Easy. Use a scrolling table in Excel using the INDEX function.
Perfectly explained, giving all necessary info without useless extras or repeating oneself. You have a very lovely voice and a nice way of speaking. Thanks.
Is it possible to adjust the reference cell based on a formula? for example, for every time I click the scroller, I want the reference cell to increase by 5%. Thanks!
Thanks, is there any method through excel by which the long list/table etc could be auto-scrolled up and down slowly,for some amount of time/infinite time?
Hi. I want to do a scrolling/fixed list but I'd like to show the 5 most recent transactions based on the current date. Can this be done or am I asking Excel too much? Please help.