Finding, then copying to a new spreadsheet

[DevGrousis]

Hey, guys, I am a complete spreadsheet newb, but as i've just started my own business i have been thrown into the spreadsheet gauntlet.

I have a manufacturer product list on spreadsheet with everything the manufacturer produces. I am only interested in certain products called "Eco-Nique <unimportant product name>". Ideally what i would like to do is to be able to find all rows with "eco-nique" and have them copy and pasted into a seperate spread sheet.

let me know if this is possible. thanks much!

 

[jim may]

You could apply the Auto-Filter to your manufg product list sheet; Filter on Products field - selecting "Eco-Nique"; All rows NOT Eco-Nique will be hidden. You can hilight the Full filtered range, Copy and Paste to your 2md Sheet's cell A1; then unfilter (Show-all) back on tyour manuf product list sheet...

Good Luck

 

[DevGrousis]

breath taking :D

thanks so much, sounds like it should do the job just perfect.

I am headed to the gym I will be trying this when I get back, and i'll let you know how it goes!