[Excel] Dynamically changing, linked drop-down list. I can't manually edit the name definitions e...
This explains how to create a variable, linked dropdown list in Excel.
When searching online, you often find methods that involve "creating each dropdown table individually beforehand, defining names for each, and referencing them using the INDIRECT function." However, this method is too cumbersome to maintain, so we've adopted a different approach here.
Yuichi Chiba
━━━━━━━━━━━━━━━━━━━━━
🎦 Playlist
━━━━━━━━━━━━━━━━━━━━━
• Excelに必須の基本知識【テーブル】の機能と使い方を徹底解説
https://www.youtube.com/playlist?list... nEyr22XVU6f1XX7nm65gamw
• Excel関数と数式のテクニック
━━━━━━━━━━━━━━━━━━━━━
✅️ Membership
━━━━━━━━━━━━━━━━━━━━━
You can check member-exclusive benefits from the link below.
/ @exceldokatach
━━━━━━━━━━━━━━━━━━━━━
✅️ Excel Workers' Gathering Place
━━━━━━━━━━━━━━━━━━━━━
🔥Latest Video🔥
【Power Query Practical Techniques】
'#0675. Retrieving, formatting, and summarizing data from multiple PDFs in a folder'
🎞️【Membership [Exclusive Video] Watch here
• #0675.フォルダ内にある複数のPDFからデータを取得・整形し一覧にまとめる
🎞️ Watch here [Excel Dokata's Gathering Place]
https://excel-dokata.mish.tv/ja/video...
💻 [Excel Dokata's Gathering Place] TOP
https://excel-dokata.mish.tv/
━━━━━━━━━━━━━━━━━━━━━
✅️ X (Former Twitter)
━━━━━━━━━━━━━━━━━━━━━
We tweet about video updates and more.
/ chiba_u1
━━━━━━━━━━━━━━━━━━━━━
✅️ Online Courses
━━━━━━━━━━━━━━━━━━━━━
🔗Excel Power Queries [Beginner Level]
https://uyrDOv.short.gy/sutoaka-class...
🔗Excel Power Queries [Elementary Level]
https://uyrDOv.short.gy/sutoaka-class...
🔗Excel Power Pivot Tables [Elementary Level]
https://uyrDOv.short.gy/sutoaka-class...
🔗Excel Pivot Tables [Beginner Level]
https://uyrDOv.short.gy/sutoaka-class...
🔗 Online Course List
https://uyrDOv.short.gy/sutoaka-teacher
━━━━━━━━━━━━━━━━━━━━━
✅️ Article Posting
━━━━━━━━━━━━━━━━━━━━━
I post articles about Excel functions, Power Queries, Power Pivot, and DAX.
https://note.com/excel_dokata
━━━━━━━━━━━━━━━━━━━━━
✅️ Contact Information for Business Inquiries
━━━━━━━━━━━━━━━━━━━━━
For inquiries regarding outsourcing, contract work, instructor requests, consulting, private lessons, etc., please contact me here.
[email protected]
━━━━━━━━━━━━━━━━━━━━━
✅️ Excel Version
━━━━━━━━━━━━━━━━━━━━━
The Excel used in this video is Microsoft 365 Personal (Office Insider Beta, the latest version at the time of video release).
━━━━━━━━━━━━━━━━━━━━━
✅️ Sample File
━━━━━━━━━━━━━━━━━━━━━
【Membership (Serious Union Members and above) Only】
• Post
━━━━━━━━━━━━━━━━━━━━━
✅️ Timestamps
━━━━━━━━━━━━━━━━━━━━━
[ 00:00 ] Introduction
[ 00:33 ] What I Want to Do
[ 06:47 ] Department Drop-Down List
[ 11:42 ] Employee List by Department
[ 15:03 ] Employee List Linked by Department
[ 20:49 ] Name dropdown list
[23:37] Change department
[26:13] End
━━━━━━━━━━━━━━━━━━━━━
✅️ Online individual consultation
━━━━━━━━━━━━━━━━━━━━━
You can consult about Excel using Zoom.
https://uyrDOv.short.gy/sutoaka-reque...