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, sh...
HansVogelaar
Feb 24, 2021MVP
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?
- EmmAayFeb 24, 2021Copper 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
- HansVogelaarFeb 24, 2021MVP
Could you provide some examples of what the output should look like?
- EmmAayFeb 24, 2021Copper ContributorI have updated it in file, Sheet 3, sample of what output folders would look like