Forum Discussion
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 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?
- I have updated it in file, Sheet 3, sample of what output folders would look like
I'm lost now. I thought you wanted to select one item from the dropdown in cell C3 on Sheet1, and then copy some data.
But the output on Sheet3 lists data for 5 different items...
- yess, thats the whole problem 😐 . it takes me hours to copy paste same cell data for different items into the different format.. and realllly need a solution to somehow automate it