|
Featured Tutorial
Featured Macro
Excel Magic Trick 295: DV Dropdown From Diff Workbook
See how to create a data validation dropdown list in 1st workbook when source list is in 2nd workbook. See the IF function with workbook cell references. See the OFFSET function used to define a dynamic range using a named formula. See the COUNTIF and COUNT functions used to count words and numbers.
Data validation drop down list.
Video made for Genevieve Atkinson.
Data validation drop down list.
Video made for Genevieve Atkinson.