T
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
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