Guilt by Association

Godzilla vs. Megalon (1973) IMDB rating: 3.40 Plot: The underground kingdom of Seatopia sends out Megalon, a giant beetle, and Gigan to destroy the above ground dwellers. In an attempt to stop them, an independently thinking robot brings Godzilla into the fight.

Actors: Sasaki Katsuhiko,Kawase Hiroyuki,Hayashi Yutaka,Dunham Robert,Tomita Kotaro,Otsuki Wolf,Nakajima Gentaro,Mikami Sakyo,Ikeda Fumiyo,Mori Kanta,Takagi Shinji,Odachi Hideto,Komada Tsugutoshi,Satsuma Kenpachiro,Jessup Rolf,Sci-Fi,

Is there a DVD of Godzilla vs. Megalon in widescreen English dubbed?
I have a widescreen copy of Godzilla vs. Megalon on DVD but it’s in Japanese with English subtitles. I wanted one that is Widescreen but English dubbed.

---

No. Sorry to say.

G. | Jul 03, 2009

Queen of the Damned (2002) IMDB rating: 4.60 Plot: After many years of sleeping in his coffin, the vampire Lestat awakens only to find that the world has changed and he wants to be a part of it. He gathers a following and becomes a rock star only to find that his music awakens the ancient Queen Akasha and she wants him to become her king…

Actors: Townsend Stuart,Perez Vincent,McGann Paul,Manon Christian,Spence Bruce,Newton Matthew,Mora Tiriel,Devoy Johnathan,Farnham Robert,Standish Conrad,Horror,Music,Fantasy,

Am I wrong for wanting to commit suicide?
Ever since the age of 6, I wanted to commit suicide. Ever since I was 6 I been called the worsted’s things you can imagine for no reason! I’ve been called ugly out load plenty times in public since I was a kid to now when I go back in fourth to work. I had a bad childhood. I was a quite kid for many reasons….teachers couldn’t stand to see me and classmates called me the ugly boy all the time all the way up to high school graduation. I even was told by a English teacher in high school that she doesn’t like when certain people look at her because it makes her feel extremely uncomfortable..she told this to the whole class but I knew she was talkin to me by the way she made that statement. Obviously she knew I was hurt after I stared at my notebook for the rest of the hour cause she apologized to me in a way a couple days later…..from then on I started realizing how people would always look the other way or cover there mouths never making eye contact while engaging in a conversation with me…..anyway my mom doesn’t like me which im ashamed to tell plenty of reason why she doesn’t….I have a lazy eye because I was born without a certain bone in my eye lid so i had to get stitches which show. My left I blinks faster then the other. I’m a short black male and people say I kind of resemble mike tyson who was charged for rape. anyway I stopped hanging out with close friends cause every time when I’m around them there’s always a joke coming out there mouths about how bad I look ….and I also never leave my house cause "seriously" there’s never one day where I can walk on to a bus, off a bus and a block away to my job or house without someone looking always covering there face or walking across the street from me. It just hurts so much….I know I look like a criminal because most people hold there purse tight when I’m near them and other things…and no, I don’t dress like a "thug" at all. I always where stuff that are high fashion…..I always end up with like 50 dollars from a 650 check because I try to impress people and not come off as a someone negative….but most times I still get nasty looks. my friends call me a person who looks like a rapist as a joke which hurts! but I dont show it that much…I usually get quite for the rest of the day and stop smiling about things that happen as the day go on…..it gets to me because I notice how women react when I’m near them which makes me feel like I have to walk across the streets from them or put my hat on then lower my head down when I’m on the bus so i want get a nasty look because of how bad I look. I always have people making a second thought about sitting near me when I’m just sitting down listening to my mp3 player minding my own business. its just way to noticeable to ignore it honestly…its just hard living life as a nice guy when everybody who doesn’t no me sees me as somethin negative I’m not…and being seen as a rapist just hurts…kills me emotionally cause I was abused when I was little by a cusin I looked up to since I had no father figure living with my mom and two sisters. I would never ever assualt a women!….damn evertime when someone looks at me weird or judge me wrong i wish i can just let them no I’m not that type of person you judge me as but I cant cause I’m a stranger…I cant just say this to random people daily..ill endup goin through more stress…and its not just my left eye that’s the problem….I’m slightly deformed by the jaw which causes my jaw to lean to the right a half of a inch away….its noticeable because I’m a African American with a …strong facial bone structure…..why should I live on? I’m ugly, short as hell, people think I like 17 but im 23 years old, nobody once to be seen with me or near me. I even tried approaching people properly by saying Hi and other ways but I know everybody thinks its just a big fake ass front! when I’m really that nice guy….everybody who knows me through my close friends always tells me the same thing after asking about me "your way different then I judged you as" "you really change my thoughts on how I shouldnt judge people" or wow your very rare I didn’t expect you were a very mature man with a good head on his shoulders…somethin kind of like that…I had one girlfriend which I treated like she was a queen…even when verbal conflicts happend between me and her I never disrespected her by calling her bad names …anyway all the guys and girls who were in bad relationships told her on the side that she can do better by getting with someone tall who looks good etc…how I was dumped 2 years into the relationship was very messed up ..I started gettin bad looks from her and other things but bein a man I couldn’t show how sensitive in weak I was to most things right…so days after she got rid of me I started thinkin every time when I think of me bein in a relationship or any relationship, I realized she and any other women can do better….I never realized how awful I looked until

---

I read your problem and was very moved by it. I’m sorry to hear about your life and more worried about how you feel about yourself and the deadly alternative that you are considering. I know how keeping things in and putting on a front because you don’t want people to know that they are hurting you feels. But, those feelings fester inside of you and eventually find a way out or give you an alternative that is not in your best interest. Dude, don’t kill yourself. I know I don’t know you and I know my words mean very little because I don’t but, I also know how you feel and trust me when I say, sometimes we don’t understand the direction life pushes us in but, when we get there which is a moment of happiness, we tend to look at all that transpired and happened to come to this result.
You definitely need counseling and a avenue to vent these feelings. Don’t keep them in, write them down in a journal with dates and times of what happened that day and how it made you feel. Find a counselor as soon as possible but in the meantime if you feel suicidal, call the hotline, talk to someone. Your life on this earth does have a purpose and if you off yourself, you will never see it. If you need to write to me, I will write back to you and listen to you. But, don’t off yourself dude. Good luck.

P.S I would like to hear the rest of what you have to say… the ending was cut off.
lasman42 | Nov 24, 2009

---

That is awful how you have been treated. I hate people who judge others just by their looks. Everyone deserves love no matter what they look like. Please don’t commit suicide, it isn’t the answer. You are a beautiful person on the inside and that is what matters. I do believe that you need to seek therapy to help you deal with what has went on in your life. And I’m sure there is someone out there for you and who will love you for you. Hang in there sweetie and God Bless You !!
mylittlehellions | Nov 24, 2009

Everyone’s Hero (2006) IMDB rating: 5.50 Plot: “Everyone’s Hero” is a heartwarming comedy-adventure, telling the story of a young boy’s thousand-mile journey to help Babe Ruth and the New York Yankees win the World Series. The project’s theme of perseverance against all odds was inspired by the film’s originating director and executive producer, Christopher Reeve.

i find Everyone’s Hero cheap

Available versions:

DivX Version (Normal Quality), iPod/iPhone Version

Actors: Macy William H.,Reiner Rob,Dennehy Brian,Wagner Robert,Kind Richard,Harris Jason,Austin Jake T.,Torre Joe,Patinkin Mandy,Whitaker Forest,Allen Ritchie,Bronstein Jesse,Coppola Ralph,Helms Ed,Iannicelli Ray,Animation,Adventure,Comedy,Family,Sport,

Ridiculous question, but…?
My friend is taking me with her to meet the Jonas Brothers backstage in a few months (long story)
It might seem highly unlikely, but do you think there’s a small, slight chance he would be interested in me?
In no way am I an obsessed fan, but he’s pretty cute. And I think it’s neat how he’s using his fame to help out.

Here’s my About Me on Facebook, if it helps

I’m Alycia [uh-lee-sha]. =)
My thanks for guiding me along the right path for 13 years go to God, Jesus & my family.
I tend to not enjoy mainstream subjects as much as older and antique things. My life is a roller coaster, but I learn to grow from each experience. The simple moments of life are beautiful to me.
It’s my dream to become a screenwriter and storyboard artist at Pixar Animation Studios one day. Andrew Stanton is my hero
I enjoy school and learning.
Stars fascinate me. Music is indigenous to me; piano keys have been under my fingertips for seven years and guitar strings for two. Singing is something I’ve always enjoyed.
Athleticism is very important to me, and baseball games are one of my favorite places to be.
I laugh at ridiculous things, yet venerate deep conversations. Get to know me well enough and you’ll bring out my inner child =)
I love my family immensely, and no matter what, I will always be my mom and dad’s lovebug <3

Anddd here I am
 http://s437.photobucket.com/albums/qq91/ xolovebug6/?action=view&current=054. jpg
 http://s437.photobucket.com/albums/qq91/ xolovebug6/?action=view&current=dscn 0591-_edit_3.jpg

Thank you to everyone kind in advance
Oh, while answering, if you could please remember the saying ‘If you don’t have anything nice to say, don’t say anything at all" that would be wonderful. ^-^

---

Just another desperate groupie?
greengo | Nov 23, 2009

---

oh dear God…
caught up in the in crowd | Nov 23, 2009

---

i used to go to school with the youngest jonas.
MicR | Nov 23, 2009

---

dont wast your time they are shithouse hype mainstream music who people just think are kool cuz there new and ppl hype it up and no he doesnt like you ur just a immiture tini bopper.
Daniel | Nov 23, 2009

---

I don’t want to burst your bubble but celebs rarely remember people from meet-and-greets or backstage passes. But I do believe anything is possible
itstimetobegin | Nov 23, 2009

---

As 13 you’re too young for any of the brothers
Somebody | Nov 23, 2009

---

If you were mature enough, you would know the answer.
Paul Singh | Nov 23, 2009

---

are you sure your friggin name is not Billie Jean?
freaking groupie
KANYE | Nov 23, 2009

---

Dear you are a gorgeous young lady, but dont expect anything to happen between you two. There are millions of people just like you wondering the same thing, but you are only 13 dear. And he is a celebrity with a very frantic schedule.
Gabe | Nov 23, 2009

---

sorry sweety not all dreams come true
JustChillin | Nov 23, 2009

---

haha! wow! you and me are almost exactly alike! except youre probably a bitprettier and im more of and mj fan than a jobro fan. i thnik that maybe if you get to see them face to face for longer than 2 mins. you might have a chance. however, youd have to make a pretty big impression because they see millions of girls every night. do somthing BIG.
Michael's Invincible! | Nov 23, 2009

Raging Bull (1980) IMDB rating: 8.40 Plot: When Jake LaMotta steps into a boxing ring and obliterates his opponent, he’s a prizefighter. But when he treats his family and friends the same way, he’s a ticking time bomb, ready to go off at any moment. Though LaMotta wants his family’s love, something always seems to come between them. Perhaps it’s his violent bouts of paranoia and jealousy. This kind of rage helped make him a champ, but in real life, he winds up in the ring alone.

find and buy Raging Bull in HD Ready:720p quaity

Available versions:

DivX Version (Normal Quality), iPod/iPhone Version, HD Ready:720p (Super Quality)

Actors: De Niro Robert,Pesci Joe,Vincent Frank,Colasanto Nicholas,Gallo Mario,Adonis Frank,Bono Joseph,Topham Frank,Scorsese Charles,Dunphy Don,Hanrahan Bill,Biography,Drama,Sport,

If God inspired the apostles to chronicle their life and times in what would become the Bible…?
…did God also inspire Vanilla Ice to pen his seminal work, dubbed "Ice Ice Baby"?

Specifically:

"Yo VIP let’s kick it

Ice ice baby (x2)
All right stop collaborate and listen
Ice is back with my brand new invention
Something grabs a hold of me tightly
Flow like a harpoon daily and nightly
Will it ever stop yo I don’t know
Turn off the lights and I’ll glow
To the extreme I rock a mic like a vandal
Light up a stage and wax a chump like a candle
Dance go rush to the speaker that booms
I’m killing your brain like a poisonous mushroom
Deadly when I play a dope melody
Anything less than the best is a felony
Love it or leave it you better gain weight
You better hit bull’s eye the kid don’t play
If there was a problem yo I’ll solve it
Check out the hook while my DJ revolves it

CHORUS
Ice ice baby vanillla (x4)

Now that the party is jumping
With the bass kicked in and the vegas are pumpin’
Quick to the point to the point no faking
I’m cooking MC’s like a pound of bacon
Burning them if you ain’t quick and nimble
I go crazy when I hear a cymbal
And a hi-hat with a souped up tempo
I’m on a roll and it’s time to go solo
Rollin’ in my 5.0
With my rag-top down so my hair can blow
The girlies on standby waving just to say hi
Did you stop no I just drove by
Kept on pursuing to the next stop
I busted a left and I’m heading to the next block
The block was dead
Yo so I continued to A1A Beachfront Avenue
Girls were hot wearing less than bikinis
Rockman lovers driving Lamborghinis
Jealous ’cause I’m out getting mine
Shay with a guage and Vanilla with a nine
Reading for the chumps on the wall
The chumps acting ill because they’re so full of eight balls
Gunshots rang out like a bell
I grabbed my nine all I heard were shells
Falling on the concrete real fast
Jumped in my car slammed on the gas
Bumpet to bumper the avenue’s packed
I’m trying to get away before the jackers jack
Police on the scene you know what I mean
They passed me up confronted all the dope fiends
If there was a problem yo I’ll solve it
Check out the hook while my DJ revolves it

REPEAT CHORUS

Take heed ’cause I’m a lyrical poet
Miami’s on the scene just in case you didn’t know it
My town that created all the bass sound
Enough to shake and kick holes in the ground
‘Cause my style’s like a chemical spill
Feasible rhymes that you can vision and feel
Conducted and formed
This is a hell of a concept
We make it hype and you want to step with this
Shay plays on the fade slice like a ninja
Cut like a razor blade so fast other DJs say damn
If my rhyme was a drug I’d sell it by the gram
Keep my composure when it’s time to get loose
Magnetized by the mic while I kick my juice
If there was a problem yo I’ll solve it
Check out the hook while Shay revolves it

Ice ice baby vanilla
Ice ice baby (oh-oh) vanilla
Ice ice baby vanilla
Ice ice baby vanilla ice
Yo man let’s get out of here
Word to your mother
Ice ice baby too cold
Ice ice baby too cold too cold (x2)
Ice ice baby"

In addition, is the verse "word to your mother" a "nod", if you will, to Mary, mother of Jesus Christ?
Mrs. C: Dedication to nothing in particular, and a steady stream of Best Answers over a period of maybe a few weeks / months (I’m guessing). Not that it’s at all meaningful. I’ve certainly "contributed" to Yahoo by subjecting everyone who views these to a barrage of Yahoo’s advertising, but it’s no more worthwhile than yet another question about God’s existence or nonexistence.

---

Yeah, and it sounds like the same god, too!

gutbucket | Nov 09, 2009

---

No kitty… this is MAH pot pie
Cartman | Nov 09, 2009

---

I guess anyone can be a top contributor. Whats it cost?
Mrs. C | Nov 09, 2009

---

Oh man… I feel violated.
Punky (R.I.P God) | Nov 09, 2009

---

Least expensive (many hours):
Take L.A. city bus to Warner Center. Take VISTA (Ventura County) bus to Camarillo.

Best route:
Take Flyaway bus from LAX to Union Station. Take Metrolink from Union Station to Camarillo. Exit station on Lewis Road side (if platform is on Dawson side of station, use pedestrian overpass to cross to Lewis Road side). Turn left on Lewis and walk under freeway. Make immediate right onto Ventura Blvd. Walk on Ventura Blvd until you pass a Good Nite Inn and a mobile home park. Turn left into outlet mall.

Most expensive:
Roadrunner and Supershuttle both have vans from LAX to Camarillo.

StephenWeinstein | Sep 06, 2008

---

Yikes, public transport won’t work, and if it did it would be four hours. If you mean LAX itself, Roadrunner Shuttle serves Ventura County (just like Prime Time or the Others) so thats an option to get there. Or Try the Santa Barbara Airporter Bus to see if they stop there.
Homer | Sep 06, 2008

---

Take stephen’s "Best Route". But make sure you check the Metrolink timetable ahead of time, as the trains are not very frequent.
gomanyes | Sep 06, 2008

---

it depends what day you are going yes metrolink would work
providing you are going during the weekday (if its Saturday or Sunday it wouldn’t work
also it depends what time you want to leave the LAX area
(morning or afternoon (as there are express buses in the afternoons to
the Valley where you can change to another express bus to Thousand oaks
but lets say that you are leaving say at 10::00am
take the LOT C bus to the LOT c terminal go to city bus terminal
the board Culver city #6 pay the driver $1.00 (that 75 cents and 25cents for a metro transfer)
take this bus to Westwood/Lindbrook
then transfer to the Metro 761 rapid
then take this bus to Ventura/Sepulveda
then board the Metro rapid 750 pay this driver $1.25
then take the 750 bus to Topanga Cyn and Ventura
transfer again to the 161 paying another $1.25 take
the 161 to the thousand oaks mall
then transfer again to the Vista bus to camarillo
Whew!
mobilemark | Sep 06, 2008

Numbers 33:38 (King James Version)

38And Aaron the priest went up into mount Hor at the commandment of the LORD, and died there, in the fortieth year after the children of Israel were come out of the land of Egypt, in the first day of the fifth month.

Deuteronomy 10:6 (King James Version)

6And the children of Israel took their journey from Beeroth of the children of Jaakan to Mosera: there Aaron died, and there he was buried; and Eleazar his son ministered in the priest’s office in his stead.

---

It is FACT and not fiction in the first place, dude.
Karl P | Nov 20, 2009

---

First, it isn’t "mythology". Perhaps Mt. Hor is IN Mosera, did you ever think of that?
Atheists are still powerless | Nov 20, 2009

---

It’s not mythology…that was your first mistake. God’s word is fact.
Kandice | Nov 20, 2009

---

To the biblical illiterate this would seem like a contradiction

But people who know, know that one place could have several names and each one can be used depending on the time and location refered to.

For instance

Lake of Gennerserate
Sea Of Gallilee
Sea Of Tiberius

All the same place

All you’ve done here junior is display for the world to see, your lack of understanding.

Well done.
No Chance Without Jesus | Nov 20, 2009

---

That was actually ancient Hebrew mythology. But dont let a lack of knowledge get in the way of your strong opinion.
apeman605 | Nov 20, 2009

---

First of all, it’s not Christian, it’s Jewish. Just because the Christians stole the book and tacked it onto the front of their "new" book doesnt mean the one they stole is actually theirs. It isn’t. It’s just a stolen book, that’s all. Futhermore they’ve managed to pervert it and made over 3000 changes in it from the original.

Perhaps you would like to read it from those to whom it actually belongs, the Jews:
 http://www.chabad.org/parshah/torahreadi ng.asp?AID=36234&p=4&showrashi=t rue
CindyComesBack | Nov 20, 2009

Proof (2005) IMDB rating: 7.00 Plot: The daughter of a brilliant but mentally disturbed mathematician (recently deceased) tries to come to grips with her possible inheritance: his insanity. Complicating matters are one of her father’s ex-students who wants to search through his papers and her estranged sister who shows up to help settle his affairs.

Download

Available versions:

DivX Version (Normal Quality), iPod/iPhone Version

Actors: Hopkins Anthony,Gyllenhaal Jake,McCarthy Danny,Daszkjewicz Tobiasz,Houston Gary,Stinton Colin,Burnett Leland,Keefe John,Chung Chipo,Harris C. Gerod,Seth Roshan,Drama,

Download Full Version>>

IS there a country that does not dispose off radioactive waste in the proper manner?
I want to know the names of the country which does not dispose off the nuclear waste in the correct manner?

Any proof ?

---

The USA is one and no control over nuclear testing in Nevada has lead to ground water pollution in Utah Nevada Some of Colorado and Arizona. That is a Fact another fact is the Cancer rates from exposure are off the map in those states. Hot area at the test sight still remain to the point that exposed items are buried there annually costing tax payers Billion of Dollars for our Governments waste. Sure that there are other countries as well poisoning our planet, North Korea , China, Russia, and parts of the Middle East.
Rusty | Nov 20, 2009

I’ve only just cottened-on to "Visti & Meyland – Yes Maam (All Nite Long) (Trentemoller Remix)"!

And YA! has the cheek to tell me its a YEAR OLD!

ESSENTIAL!

---

wow

Punch's Purple Jukebox | Nov 25, 1904

Does anyone like bestbuy have macs on sale during blackfriday?

---

Check this website out..
Lauren P | Nov 23, 2009

---

Best buy does not live up to their name – their prices are the retail price found on a company’s website
not 2 B fooled | Nov 24, 2009

I have an excel sheet, in my sheet I have field force data like this
S#NameDesignationTerritoryGroup
1Razi uddin AhmedA.MKarachiL+P
2Zishan BadarS.P.OKarachiGeneral
3VacantS.P.OKarachiPoultry Nawan
4Iftikhar HussainA.M.HyderabadL+P
5M. Tariq Khan S.P.OHyderabadPoultry Nawan
6Dr. Chandar Kumar S.P.OHyderabadGeneral
7Waheed Aslam ChistiA.MMultanL+P
8Mohammad Shahid S.P.OMultanPoultry Nawan
9Mohammad ZahidS.P.OKhanewalPoultry Nawan
10Hafiz Samiullah S.P.OR.Y.KhanPoultry Nawan
11Mohammad Rashid S.P.OMultanPoultry Pameer
12VacantAM
13Mohammad BilalS.P.O (Group-B)MultanGroup-B Livestock
14Mohammad Mosa RazaS.P.O (Group-A)MultanGroup-A Livestock
15Farooq AhmedS.P.OD.G KhanGeneral
16Khalid MehmoodS.P.OVehariGeneral
17Mohammad Muneer S.P.OBhawalpur General
18Ghulam Mohyy uddinS.P.OR.Y.KhanGeneral
19Shehzad ButtTMLahorePoultry Nawan
20Mohammad Amin S.P.OLahorePoultry Nawan
21Mohammad Junaid ArshadS.P.OGujranwalaPoultry Nawan
22Aftab Bodhla S.P.OLahorePoultry Pameer
23Nisar AhmedAMGujranwalaLivestock
24Waheed AnwarS.P.OKasurGeneral
25Mahmood ul Hasan S.P.O (Group-A)S.PuraGroup-A Livestock
26Rizwan ul Haq S.P.O (Group-B)S.PuraGroup-B Livestock
27Muhib AliS.P.OGujranwala + HafizabadGeneral
28M. Nasir YaminS.P.ONarowalGeneral
29Dr Hasib AhmedRSML+P
30VacantAM
31Naveed Ahsan ShahS.P.OFaisalabadPoultry Nawan
32Farrukh Zafar S.P.OSargodhaPoultry Nawan
33Hafiz Tahir Iqbal S.P.OSahiwalPoultry Nawan
34Kh. M NaeemS.P.OFaisalabadPoultry Pameer
35Kashif Memood AlviS.P.O (Group-B)FaisalabadGroup-B Livestock
36Ghulam MurtazaS.P.O (Group-A)JaranwalaGroup-A Livestock
37Saqib Nazir S.P.OSGD + Khushab + MainwaliGeneral
38Khalid Naseer S.P.OSahiwalGeneral
39Hafiz Numan AshrafS.P.OJhangGeneral
40Ghous Baksh NadirS.P.OBhakkarGeneral
41Asif AzizA.MRawalpindiL+P
42Mohammad Asim S.P.ORwp + Gujrat Poultry Nawan
43Naeem ur RehmanS.P.OTLG+ChakwalGeneral
44Haroon ur RasheedS.P.ORawalpindiPoultry Pameer
45Syed Mohammad HussainS.P.ORawalpindiGeneral
46Mohammad Ijaz AnsariS.P.OGujratGeneral
47Mujahid AkbarA.MPeshawarL+P
48Masood ShahS.P.OPeshawarPoultry Nawan
49Shah Faisal S.P.OPeshawarPoultry Pameer
50Mr. Abdur RehmanS.P.OPeshawarGeneral
51Tauseef AmedS.P.OD.I KhanGeneral
52Mohammad Naeem S.P.OSwatGeneral
is it possible that in sheet 2 when I Type group Like General in cell a1 the detail of SPOs’ of General Group will automatically entered from range a4, and when I type territory like Lahore in cell b1 the detail of SPOs’ of Lahore will automatically entered from range a4, or when i type Designation Like S.P.O in cell c1 the detail of SPO will automatically entered from range a4. Please tell me how to do this with excel or vba

---

Try this first and then let us know if you still want exactly what you asked for.

In Excel 2007_________________

On Sheet 1 (0r a copy of Sheet 1in Sheet2, if you wish) select all five columns that contain data and then select Data > Filter

Squares with small triangles in them will appear at the right edge of the Row 1 cells. Click on the one in Column E (the cell should say Group) and (among some other things) a group of check boxes will appear.

The first check box is labeled (Select All) the rest are labeled with each unique value in the column. Check the boxes for the values you want to see and select OK. Try different combinations to see what happens.

You can do this with any column. Just realize that any column filter just considers what has not been eliminated by selections in other columns. So you will usually want to Select All on most columns.

Selecting Data > Filter again will remove all filters and display all of the data.

For Excel versions before 2007____________________

Read trough the Excel 2007 section first and then proceed.

Select all of the data columns and then select Data > Filter > Auto Filter. Everything will be the same as in Excel 2007 except your choices of what to display will be limited to All or any one value at a time. Selecting Data > Filter > Auto Filter a second time will remove filtering.

____________________________

If this doesn’t meet your needs, a less flexible macro could be written. Just expand the question to indicate that is what you prefer and a little about why so that the macro is more likely to meet your needs.

Gary E | Jan 01, 2009

---

Ideally, the fields in the data being imported to Excel will be delimited by a tab or some other character. If it isn’t, the fields should be fixed length. Once the data has been imported, you can use Excel’s data filtering so the program will only display records having specified values in a given column.

If the input data is not delimited or fixed length, the task of getting the data into separate worksheet cells is almost impossible, even with VBA. So make sure the data is provided in a delimited format before importing.
rknoblock | Dec 31, 2008