Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature?
Loading...
Loading...
23,933
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (31)
-
You're my hero! I've been struggling with the "no blanks" on data validation lists thing for ages and this method of dynamic named ranges is SUPERB.
Thanks
-
@jimaldo64 , No List in Excel 2020. OFFSET will work in any version.
-
I'm using excel 2002, there doesn't seem to be a "create table" feature :-(
if i have to use offset, will my 'tables' still work in newer versions of excel?
Loading...
6:39
Excel Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Drop-Downby ExcelIsFun22,309 views- 7:11
Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheetby ExcelIsFun33,609 views
- 5:59
Excel Magic Trick # 259: Dynamic DV List Based On DV Listby ExcelIsFun28,432 views
- 9:45
Excel Magic Trick 584: Dynamic Range for Periodic Data Dumps into Excel OFFSET & Defined Namesby ExcelIsFun5,918 views
- 7:01
Excel: Drop-Downs(Combo Box) and Conditional Formatting (Voice Tutorial)by iProRyan35,554 views
- 7:34
Excel Magic Trick 606: INDEX & MATCH Two Lookup Valuesby ExcelIsFun15,031 views
- 5:06
Create dependent drop down lists in Excel.aviby Computergaga5,839 views
- 11:33
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Throughby ExcelIsFun11,544 views
- 1:35
Excel lookup with multiple conditions! (extended vlookup)by Psychotec13,103 views
- 8:05
Excel Magic Trick 534: Conditional Formatting for Weekends and Holidaysby ExcelIsFun24,224 views
- 6:45
Linking Data from Different Excel Sheets and Workbooksby ExcelFormulas19,493 views
- 10:56
Excel Magic Trick #171: MACRO Data Validation from 3 listsby ExcelIsFun15,795 views
- 23:31
Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filterby ExcelIsFun8,777 views
- 6:07
CONSOLIDATIONby aimansadeq9,925 views
- 3:36
Excel Data Validation Automatically Add Items to Drop Down Listsby contextures11,090 views
- 12:01
Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclatureby ExcelIsFun7,370 views
- 10:34
YTL Excel #126: VLOOKUP & INDIRECT & COLUMN functionsby ExcelIsFun12,854 views
- 7:09
MS Excel: Advanced Data Validation using Listby RaiNtrospection17,554 views
- 10:32
Excel Magic Trick #148: Dynamic List from Table #3by ExcelIsFun15,119 views
- 10:29
Excel Magic Trick 774: Dynamic Data Validation AND Dependent Data Validation Togetherby ExcelIsFun4,605 views
hey I have a quick question about copy and pasting. This may be very trivial but I just cant figure it out. On my sheet2 I hvae a table all set up and on my sheet1 I have some cells setup as data validation and referencing the table on sheet2. Everything works fine and how I want it. BUT if I try to copy those cells in sheet1 and paste them, say, down a few cells then the table refernces change. How do I lock the location of the table so when I copy and paste, it wont change the table location?
hyperscitic92a 3 weeks ago
@hyperscitic92a , try this video:
Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation
ExcelIsFun 3 weeks ago
@ExcelIsFun
WOW my excel project works like a champ now! That fixed it.
Thank you so very much for sharing your knowledge with us all. I sincerely appreciate it.
take care and keep up the great work!
hyperscitic92a 3 weeks ago
@hyperscitic92a , cool!!!
ExcelIsFun 3 weeks ago
So appreciative - nice presentation, concise, easy to follow. You answered all of my questions in 3 minutes. Bless you!
calewis55 1 month ago
@calewis55 , I am glad that it helped!
ExcelIsFun 1 month ago