Paginated report (kind of) in #Excel

When we build Excel Dashboard, real estate is precious. We cannot fit everything on a single dashboard, although it's a common request to. 😅

Say, you have a table with the sales data of 1000 items, in descending order. You boss want you to insert a table in an Excel Dashboard showing the Top 10 items. That is easy. However your boss has one more requirement: s/he should be able to select top 11 to 20, 21 to 30 times in that table... No indeed your boss wants the flexibility to see all items in the table that is placed on a dashboard. If this is familiar to you, you should watch this video.

You may download a sample workbook from my blogpost to follow along.
https://wmfexcel.com/?p=21532

If you like this video, please give a thumb up, share, leave a comment and subscribe my channel. 😉

00:00 Introduction of the problem
00:30 Expected result
01:15 Use of CHOOSEROWS
02:25 Use of SEQUENCE
05:00 Insert Form Controls (Spin Button)
07:25 Putting together

Тэги:

#Excel #Tips_and_Tricks #wmfexcel #BeExcellence #Excel_365 #Dynamic_Array #SEQUENCE #CHOOSEROWS

Скачать видео