Microsoft Excel - Limited Scroll List (with VBA Trick-shot)

[@SaniGarba]

You are a natural Excel maestro. Thanks. You seem to skip mentioning the need to save the file as macro-enabled not as the regular xlsx.

[@bcti-bcti]

Ah, that is an excellent point. I should have mentioned that. Thanks for letting me know.

[@chrism9037]

Great video! The Sales Rep names made me chuckle

[@bcti-bcti]

Thanks. I'm glad someone noticed. I wish I could use some of the more inappropriate names, but this is a family channel.

[@Bienvo0921]

Just one word.... EXCELLENT!

[@bcti-bcti]

Just one word....THANKS!

[@robbe58]

Another great solution to use on smaller screens or laptops. As always, your explanation is clear, ordered and documented in an excellent way. Very useful. Thank you.

[@bcti-bcti]

@@robbe58 Thanks. I’m glad you found it useful, loyal viewer. 👍🏼

[@michaeldingee743]

I watch all of your videos when they come out. I use many of your solutions for specific things I am working on. This one I can use for a specific report. I changed the formula to a let function. =LET(hrow,(HSTACK("#",CHOOSECOLS(MyData[#Headers],1,3,4,5))), seq,SEQUENCE(25,1,K2+1,1), list,TAKE(DROP(CHOOSECOLS(FILTER(MyData,MyData[Region]=UserRegion),{1,3,4,5}),K2),25), row,HSTACK(seq,list), VSTACK(hrow,row))

[@bcti-bcti]

My friend, you are singing my song!!!! I love writing single-cell, complete table formulas. It's so cool that Excel can do these things. It's a shame most users won't take the time to learn LET functions and all the associated functions. GREAT JOB!!! 10 out of 10!

[@iankr]

Great techniques! Many thanks.

[@bcti-bcti]

Thank you for saying so. I appreciate you watching a long-form video.

[@skylineg6618]

I literally was wondering if something like this was possible yesterday. Amazing

[@bcti-bcti]

@@skylineg6618 Perfect timing. Thanks for watching.

[@eranberl]

Great video!

[@bcti-bcti]

Thanks! We appreciate you taking the time to watch.

[@StevenCampbell-x3z]

@@bcti-bcti Thanks

[@TheMarkGross]

The techniques are useful. I would have struggled to learn to subtract 25

[@bcti-bcti]

@@TheMarkGross We’re glad you found them useful. Thanks for watching.

[@pierre-yves_david]

You have made me discover the choosecols function. I'm wondering if some of the absolute reference (like "$C$1") could not be replaced by a "UserRegion" reference to improve its maintainability.

[@bcti-bcti]

Great idea. The updated line of code would be as follows: If Target.Address = Range("UserRegion") Then Thanks for asking such a great question.

[@FsoOmar]

Love it, a handy scroll bar. Darn! I only have Excel 2021, but thank you, indeed.

[@bcti-bcti]

Yeah, there are a few of these functions that require Office 365. Time to upgrade 😁