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.
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!
AWESOME VIDEO ANNIE , THANKS ALOT
Awesome tutorial, Anny.
what if you need a scrollbar for a dynamic table that is continuously receiving new data?
Hey great workbook. I just love this file. Thanks Annie
Awesome explanation. Keep it up. Thanks a lot dear.
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?
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?
Is this feature available on Apple Numbers? Or Google Sheets? If so, please make a tutorial!
Brilliant_Stuff...so_Helpful_in_Dashboard_building.Thanks_a_million.
My pleasure! :)
Amazing vid need to add this to my arsenal 😂
How about adding a filter on the scroll table but in reference to the raw data?
can you do put this in powerpoint?
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.
I can't seem to make the scrollable table work when adding filters to the first table.
How will I get it horizontally?
where is the link for the Index function video link you mentioned?
ua-cam.com/video/6coBN0gyZKY/v-deo.html
Hi, lovely tutorial. I'm just wondering why you subtracted 9 from the max value? Did I miss out on anything? O_O
very nice. thank u for sharing.
+James Perry My pleasure!
THANK YOU!!!!!
nice!