Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help me
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help me
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|