Select from Drop-down and Pull Data from Different Worksheet in Excel

Microsoft Excel Tips and Tricks

In this video I demonstrate how to extract data from a specific worksheet based on that worksheet name being selected in a drop-down list. To achieve this you need to understand the syntax used when referencing cells on another worksheet. You also need to know about the INDIRECT function.

Credit Chester Tugwell

Please support our Sponsors here :