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.
![[DRIP] ‘Love, Maybe’ PREVIEW](http://i.ytimg.com/vi/U7hwHp95m1k/mqdefault.jpg)
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.
Lol! Thanks, Klik!
Awesome video. Super informative. I like how you explain the little shortcuts you use along the way. Very nice job.
Thanks! Glad it helped you!
what if you need a scrollbar for a dynamic table that is continuously receiving new data?
Nice tutorial. How to do scroll bar for an empty table and then you will scroll down for empty cells to fill them in. Is possible at all?
Hey great workbook. I just love this file. Thanks Annie
Is this feature available on Apple Numbers? Or Google Sheets? If so, please make a tutorial!
AWESOME VIDEO ANNIE , THANKS ALOT
Great help from this video ,Thanks Annielytics
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?
Awesome explanation. Keep it up. Thanks a lot dear.
How about adding a filter on the scroll table but in reference to the raw data?
Amazing vid need to add this to my arsenal 😂
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.
Awesome tutorial, Anny.
Brilliant_Stuff...so_Helpful_in_Dashboard_building.Thanks_a_million.
My pleasure! :)
I can't seem to make the scrollable table work when adding filters to the first table.
where is the link for the Index function video link you mentioned?
th-cam.com/video/6coBN0gyZKY/w-d-xo.html
Hi, lovely tutorial. I'm just wondering why you subtracted 9 from the max value? Did I miss out on anything? O_O
can you do put this in powerpoint?
How will I get it horizontally?
very nice. thank u for sharing.
+James Perry My pleasure!
THANK YOU!!!!!
nice!