On Tuesday, September 11, 2012 11:24:56 AM UTC-4, TIMOTHY wrote:
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