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...
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