Excel Forum
Similar Content
Get Data from Separate Workbooks in Excel
Tutorial: How to get data from separate workbooks in Excel. This tutorial includes an example using ...
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...



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.