Forum Discussion
EmmAay
Feb 24, 2021Copper Contributor
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.
You'll need a VBA macro to copy the data to a new workbook, not formulas.
If you want help with that, could you attach a sample workbook without sensitive data?
- EmmAayCopper Contributor
HansVogelaar https://1drv.ms/x/s!AtO4cLU3LQyswGFUbHAPPKG_erW8?e=h1WwBY
here is the link, the simplest form of the sheet i could make to give you the idea
Could you provide some examples of what the output should look like?