Forum Discussion

EmmAay's avatar
EmmAay
Copper Contributor
Feb 24, 2021

Formula to extract data from sheet with drop down menu

Hi,

So i have a sheet which includes A LOT of data for different items. The sheet is designed as such that it has drop down menu at top, and list contains about 25 items. Each item when selected, shows the data below in about 19 columns. 

 

What i want, is to create another workbook, and link it to the master file, and it only populates data of like selective items from that list of 25, and puts it in another format of my choosing.

 

write now if i use Vlookup, or IF statement, the data does get extracted into another sheet, but as soon as i choose another item from dropdown of master sheet, the data in secondary sheet changes as well.

 

Any help? i haven't been able to find solution anywhere on web for it.

Resources