Help me

[TIMOTHY]

i have a three sheet of which two dont have any data

one sheet has dataName Price Format Brand
SAMPOORNA CHALISA SANGRAH 110 Audio CD T-series
BARFI ! 175 Audio CD sony
HEROINE 175 Audio CD sony
THE SON OF NO ONE 499 DVD Big Music
KRISHNA AUR KANS 299 DVD Big Music
THE BIG BANG 499 DVD Big Music
FROZEN PLANET 999 DVD Big Music
SACRIFICE 499 DVD Big Music
THE NEXT THREE DAYS 499 DVD Big Music
TRESPASS 499 DVD Big Music
KILLERS 499 DVD Big Music
CASINO JACK 499 DVD Big Music
BEST OF 2012 395 Audio CD Universal
FLASHBACK ASHA BHOSLE 150 Audio CD SAREGAMA
KAMAAL DHAMAAL MALAMMAL 160 Audio CD T-series
INSTRUMENTAL BRIAN SILAS & ENOCH DANIELS 175 Audio CD SAREGAMA
DIAMONDS FOREVER MD.SIDDIQUE / RANJIT KAUR 150 Audio CD SAREGAMA
THE FLAUTIST – PT.RUPAK KULKARNI 295 Audio CD SAREGAMA
GOLD FOREVER LOVE DUETS ASHA & RAFI 150 Audio CD SAREGAMA
RAGA REFLECTIONS 295 Audio CD SAREGAMA
GOLDEN MOMENTS CHALLA 75 MP3 SAREGAMA
LEGENDS RAJESH KHANNA 1000 Audio CD SAREGAMA
ENGLISH VINGLISH 160 Audio CD T-series
JAI SHRI MANGAL MURTI GANARAJA 99 Audio CD WWR
GANESH 99 Audio CD WWR
GULLIVER’S TRAVEL 149 DVD SHEMAROO
THE ESSENTIAL GIPSY KINGS 499 Audio CD sony
SHUBH - VINAYAK 150 Audio CD SAREGAMA
COMBOS DHAMAKA 99 Audio CD Universal
KING OF ROMANCE RAJESH KHANNA VOL 3. 349 DVD SHEMAROO
COMBOS DHAMAKA SHOLAY + QURBANI + GERAFTAAR + ROCKY 99 mp3 Universal
CARRY ON JATTA 199 DVD SHEMAROO
INSAAN AUR SHAITAN 149 DVD SHEMAROO
JUARI 149 DVD SHEMAROO
RUI KA BOJH 199 DVD SHEMAROO
GOLDEN TRIO 350 DVD SHEMAROO
YOGA LATES 299 DVD Times
BEST OF U.SRINIVAS 399 Audio CD sony
GHAZAL PAIKAR 350 Audio CD sony
BEST OF ALLA RAKHA & ZAKIR HUSSAIN 499 Audio CD sony
101 % SUPER –DUPER HIT BHANGRA 155 Audio CD SPEED RECORDS
BOHEMIA – THOUSAND THOUGHTS 150 Audio CD sony
LOOK & LAK 155 Audio CD SPEED RECORDS
MAHANAYAKA 199 Audio CD SAREGAMA
EK MAIN AUR EK TU IMMORTAL DUETS 50s TO 2004 750 Audio CD SAREGAMA
WINGS TO FREEDOM 399 Audio CD SAREGAMA
RAKHTBEEJ 199 DVD MAGNA
ICCHAPURTI SHREE HANUMAN CHALISA 75 Audio CD GIPSY
DJ SUKETU & FRIENDS PRESENT RD BURMAN REINVENTED 195 Audio CD VIRGIN
MERE DOST PICTURE ABHI BAKI HAI 199 DVD SHEMAROO
JAB TAK HAI JAAN


using vba i want to filter saregama and Audio CD and copy the data to another sheet

 

[benmcclave]

i have a three sheet of which two dont have any data



one sheet has dataName Price Format Brand

SAMPOORNA CHALISA SANGRAH 110 Audio CD T-series

BARFI ! 175 Audio CD sony

HEROINE 175 Audio CD sony

THE SON OF NO ONE 499 DVD Big Music

KRISHNA AUR KANS 299 DVD Big Music

THE BIG BANG 499 DVD Big Music

FROZEN PLANET 999 DVD Big Music

SACRIFICE 499 DVD Big Music

THE NEXT THREE DAYS 499 DVD Big Music

TRESPASS 499 DVD Big Music

KILLERS 499 DVD Big Music

CASINO JACK 499 DVD Big Music

BEST OF 2012 395 Audio CD Universal

FLASHBACK ASHA BHOSLE 150 Audio CD SAREGAMA

KAMAAL DHAMAAL MALAMMAL 160 Audio CD T-series

INSTRUMENTAL BRIAN SILAS & ENOCH DANIELS 175 Audio CD SAREGAMA

DIAMONDS FOREVER MD.SIDDIQUE / RANJIT KAUR 150 Audio CD SAREGAMA

THE FLAUTIST – PT.RUPAK KULKARNI 295 Audio CD SAREGAMA

GOLD FOREVER LOVE DUETS ASHA & RAFI 150 Audio CD SAREGAMA

RAGA REFLECTIONS 295 Audio CD SAREGAMA

GOLDEN MOMENTS CHALLA 75 MP3 SAREGAMA

LEGENDS RAJESH KHANNA 1000 Audio CD SAREGAMA

ENGLISH VINGLISH 160 Audio CD T-series

JAI SHRI MANGAL MURTI GANARAJA 99 Audio CD WWR

GANESH 99 Audio CD WWR

GULLIVER’S TRAVEL 149 DVD SHEMAROO

THE ESSENTIAL GIPSY KINGS 499 Audio CD sony

SHUBH - VINAYAK 150 Audio CD SAREGAMA

COMBOS DHAMAKA 99 Audio CD Universal

KING OF ROMANCE RAJESH KHANNA VOL 3. 349 DVD SHEMAROO

COMBOS DHAMAKA SHOLAY + QURBANI + GERAFTAAR + ROCKY 99 mp3 Universal

CARRY ON JATTA 199 DVD SHEMAROO

INSAAN AUR SHAITAN 149 DVD SHEMAROO

JUARI 149 DVD SHEMAROO

RUI KA BOJH 199 DVD SHEMAROO

GOLDEN TRIO 350 DVD SHEMAROO

YOGA LATES 299 DVD Times

BEST OF U.SRINIVAS 399 Audio CD sony

GHAZAL PAIKAR 350 Audio CD sony

BEST OF ALLA RAKHA & ZAKIR HUSSAIN 499 Audio CD sony

101 % SUPER –DUPER HIT BHANGRA 155 Audio CD SPEED RECORDS

BOHEMIA – THOUSAND THOUGHTS 150 Audio CD sony

LOOK & LAK 155 Audio CD SPEED RECORDS

MAHANAYAKA 199 Audio CD SAREGAMA

EK MAIN AUR EK TU IMMORTAL DUETS 50s TO 2004 750 Audio CD SAREGAMA

WINGS TO FREEDOM 399 Audio CD SAREGAMA

RAKHTBEEJ 199 DVD MAGNA

ICCHAPURTI SHREE HANUMAN CHALISA 75 Audio CD GIPSY

DJ SUKETU & FRIENDS PRESENT RD BURMAN REINVENTED 195 Audio CD VIRGIN

MERE DOST PICTURE ABHI BAKI HAI 199 DVD SHEMAROO

JAB TAK HAI JAAN





using vba i want to filter saregama and Audio CD and copy the data to another sheet

Take a look at the macro below from www.ozgrid.com/News/sep-2010.htm. You'll need to name some ranges for it to work, but it should do the trick.

Sub GetData()
'http://www.ozgrid.com/News/sep-2010.htm
Range("Results").Clear

Range("DataTable").AdvancedFilter xlFilterCopy, Range("Criteria"), Range("Results")(1, 1)

If Range("Results")(2, 1) = vbNullString Then
Range("Results").Clear
MsgBox "No results matching criteria", vbInformation
End If
End Sub