Excel Forum
Similar Content
Import a Worksheet from One Workbook to Another in Excel
Tutorial: In Excel, you can quickly copy an entire worksheet from one workbook to another workbook....
Macro to get Data from Another Workbook in Excel
Tutorial: Macro to get data from a workbook, closed or open, over a network or locally on your comp...
Combine Worksheets from Multiple Workbooks into One
: Excel macro that allows you to select multiple workbooks and have all of their worksheets ...



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.





Got a Question? Ask it Here in the Forum.