Microsoft Excel Tips and TricksIn 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 :