Download the featured file here: [ Ссылка ]
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.
Table of Contents:
00:00 - Introduction
00:20 - How to create a drop-down list of worksheet names
01:22 - Understanding the syntax for referring to cells on another worksheet
01:49 - Understanding the INDIRECT function
02:51 - How to refer to worksheet names that contain spaces
04:48 - Perform a VLOOKUP across worksheets
08:11 - Use the COLUMN function to automate the col_index_num
------------------------
