Finding, then copying to a new spreadsheet

DevGrousis

New Member
Joined
Jan 11, 2011
Messages
2
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!
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

jim may

Well-known Member
Joined
Jul 4, 2004
Messages
7,480
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

New Member
Joined
Jan 11, 2011
Messages
2
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,206
Messages
5,600,302
Members
414,375
Latest member
Onmyown

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top