Link to home
Start Free TrialLog in
Avatar of gabriel davis
gabriel davis

asked on

[Excel Help] If cells says a word pull that info into another sheet

I am a totally noob at excel, but I am building one for my job. Basically what I need is for excel to pull a category name from row C  and make the selected words go to sheet 2

Product Name      Category Name      Current Level      Location
apples                     food                          50
paper                      paper                        1000
candy                      sweets                      50


I need to take the category name and single out all those onto a different sheet for a more detailed list of each category name.
Hopefully this makes sense.

Thanks,
Animosityheals
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.