+ Reply to Thread
Results 1 to 5 of 5

Could someone HELP TRANSLATE this simple psuedo code into MACRO please?!

  1. #1
    Registered User
    Join Date
    03-16-2006
    Posts
    38

    Exclamation Could someone HELP TRANSLATE this simple psuedo code into MACRO please?!

    HTML Code: 


    (see below for explaination)

    I have a Excel workbook called FIRSTAM8.xls

    Inside I have two seperate worksheets: 1)'DATA' & 2)'WORK'
    There are 31886 rows in sheet 'WORK' & 5741 rows in sheet 'DATA'

    Column 'C' in 'WORK' contains the customer name, Column 'B' contains the zip code.

    In the 'DATA' sheet Column 'H' contains the customer name, & Column 'S' the zip code.


    I want to compare (individually, one-by-one) the zip && name Columns ('B' & 'C')
    of each row in sheet 'WORK' to/with/against the respective
    zip && name Columns ('S' & 'H') of EACH AND EVERY row in sheet 'DATA'.

    For example: if BOTH the zip &&and&& name columns of row1 of sheet 'WORK' matches
    with ANY (any of the 5741) rows of sheet 'DATA' then row1 IS a match/hit,
    and the entire row1 of sheet 'WORK' is highlighted yellow to indicate the match status.
    If row1 of 'WORK' matches to multiple rows of 'DATA' that is okay, it is still highlighted.
    However if row1 of 'WORK' does not match (by the criteria of zip && name) to ANY of the
    5741 rows in "DATA" then it is not highlighted and the next row (row2) is processed.

    Note: When comparing names, I really mean comparing the first
    character of the customer name fields. I do this to avoid
    false negatives and so not to miss a potential match.
    This will entail using the substring manipulation functions.(?LEFT)

    --------------------

    HTML Code: 

    *OR*

    HTML Code: 

    CAN SOMEONE TRANSLATE THE ABOVE INTO REAL EXCEL CODE FOR ME??



    Here is a link to the ENTIRE post I made (for clarity and reference):
    http://www.ozgrid.com/forum/showthread.php?t=49941

    Here is an abridged IMAGE of the my Excel Workbook:
    finalj.JPG

    Here is the original file I am working on (LARGE):
    FIRSTAM8.xls
    http://www4.sendthisfile.com/d.jsp?t...Oeb2puKBql1LmB

    Thanks,
    Bo
    Last edited by bxc2739; 04-27-2006 at 12:39 PM.

  2. #2
    Registered User
    Join Date
    03-16-2006
    Posts
    38

    Translation of simple code?

    Here is the original file I am working on (LARGE):
    FIRSTAM8.xls
    http://www4.sendthisfile.com/d.jsp?t...Oeb2puKBql1LmB

    Here simple IMAGE illustration:
    finalj.JPG

    I just need the BELOW pseudo code translated/coverted into REAL Excel MACRO code:

    HTML Code: 

    :I just need the ABOVE pseudo code translated/coverted into REAL Excel MACRO code

    Thanks

  3. #3
    Registered User
    Join Date
    03-16-2006
    Posts
    38

    Exclamation

    . .

  4. #4
    Registered User
    Join Date
    03-16-2006
    Posts
    38
    . .

  5. #5
    Registered User
    Join Date
    03-16-2006
    Posts
    38
    The America SAD DENIAL Case

    Your war against Fear is not justified. It is actually a Resource War for oil, and a currency war for the dollar. Global Oil production has peaked and US will suffer the most from this crisis. The United States uses 25% of the world’s oil yet only has 5% of the world’s population. America is heavily in debt and bankruptcy is unavoidable. The coming housing bust will send the economy into a second greater depression.

    While the Middle East countries find themselves targets in the "war on terror", China, Russia, and Latin America find themselves targets in the recently declared and much more expansive "war on tyranny." Whereas the "war on terror" is really a war for control of the world's oil reserves, this newly declared "war on tyranny" is really a war for control of the world's oil distribution and transportation chokepoints.

    The dollar is in collapse, the economy is going to crash, oil is getting more scarce everyday. America is a nation that has its infrastructure built exclusively to be run on abundant cheap oil, with global demand of oil increasing exponentially and supply decreasing year after year, America has no other choice than to wage a global war on oil and currency and under the ruse of terror and freedom.

    What? No believe? You still denial??


    Remember when Saddam backed down? Its been so long even MY memory's
    been washed by Washington, but before the WMB bullshit we were hearing ranting and trash from Bush that it was because of Iraq's Al Samoud 2 missiles had 10 miles extra range than allowed by the UN [funny how US itself never follows UN regulations] that the US was going to attack Iraq. Al Samoud 2 was a big issue for a while, and Bush gave Saddam an ultimatum of a week or so to disarm and destroy all 90 some missiles or else the US EVIL EMPIRE was going to attack....

    what happened?

    Saddam disarmed all missiles.

    and then...

    US Charged in with Guns a Blazing....
    SHOOT FIRST THEN ASK questions torture...

    Quick Draw Trigger Happy Cheney saying GO **** YOURSELF to the world.


    The point is, North Korea, Iran and indeed the rest of the world saw this and learn from Iraq's lesson. When dealing with EVIL like the US WHEEL OF EVIL EMPIRE there is no use in disarming your own weapons!!!!
    Any country that still does that is PLAIN STUPID!!! LOOK WHAT HAPPENED TO IRAQ!!!!

    The Native Americans was too slow to learn the lesson, Iraq was too dumb to learn the lesson. Lets hope Iran does a pre-emptive strike FIRST this time and give Shrub a taste of his own medicine!!!


    Now, to be fair I realize most Americans do not take lightly to criticism. But what about reason? Logic? Or plain common sense?

    You seem to agree with the doctrine of pre-emptive strike correct? You say that if you know your enemy will attack you anyway, that it is your duty and obligation to attack them first to prevent damage to yourself.

    So when I that Iran should attack America’s military and not wait until it is first attacked upon, what then do you have to object? I am simply praticing YOUR DOCTRINE OF PRE-EMPTIVE STRIKE. If an enemy [the US in this case], will attack you anyway, (like how America will attack Iran, and how US with its proven track record DID attack Iraq) it is then Iran's duty and obligation to pre-emptive the pre-emptive strike. America has proven TIME AND TIME AGAIN that is PRACTICES THE DOCTRINE OF STRIKING FIRST, so why the hell should other nations not do the same? If I know a bully in my neighboorhood already took out 5 of my neighboors why the hell should I not practice what he does and take HIM out first?

    So if you [US] can do it, why can no other country practice the same thing?

    Let us not forget one of your major characteristics: your duality in both manners and values; your hypocrisy in manners and principles. All*manners, principles and values have two scales: one for you and one for the others.




    What? No believe? You still denial??

    Don’t forget what horrible unspeakable atrocities your nation did to the Native Americans who were here before them.


    America is not a legitimate nation. It is a British renegade colony that should have been repatriated. The Evil Colony of America and the Evil Treacherous George Washington General Coward betrayed his own England and set up this Avarice Nation. The Evil American Colony sent a bitching letter to King George and in essence said they were tired of paying their fair share of the taxes, but used the ruse of ‘taxation without representation’ as a pitiful pathetic excuse to cheat the motherland of resources.

    This is true beginning of the EVIL AVARICE NATION that you so ardently defend.
    This nation later went on and killed all the Native Americans. This is the Evil nation that usurped land from the French and called it a so called “Louisiana Purchase”. That’s like me going to the BMW car dealership and driving off with the latest 760Li and paying only 15 cents. That’s a ‘purchase’ all right… Do I need to remind you America Robbed Texas from Mexico? And then the Evil wasn’t satisfied so it did a pre-industrial version of Operation Northwood’s and then went down to the capital of Mexico and forced the Pres. Of Mexico to give away all the rest of the West to the US Wheel-Of-Evil Empire.

    Any nation that steals so VAST amount of virgin LAND, Territory, resources, will of course attract talent like light attracts flies. This is Darwinism in action here. Greediest of the Greediest people of the world immigrate the America. These Avaricious lovers of Lust and Evil procreate and mingle with other fellow most-greedy-of-the-earth evil lovers and pretty soon of a few short generations you have most avaricious, self-serving, underhanded, egoistic, hypocritical, lustful, greedy SOBs in the entire universe.

    Nothing America has belonged to America. Nothing Americans have achieved was because of America itself. This country is one big party of a free ride that runs on the rape, murder, torture, usurping, robbery, thievery, hijacking, empirizing, conquering,
    Of other peaceful innocent nations. It has never done anything good for anyone except itself own selfish pig citizens.



    I’m sure some Americans will do anything to defend the name of their country and their lifestyle, despite all facts to the contrary. Is that not as powerful or perhaps more powerful than Middle Eastern religious zeal? Too bad for the Middle Eastern religious nuts who don't know this, but in this world those with big weapons & Advanced Killing Machines ALWAYS WIN.. The existence of American in this universe proves that there is no justice and fairness in this world, and also that there cannot possibly be any ‘God’, for no God would be so cruel. Foolish Muslims….

    It is not so bold an assertion nor an exaggeration to make to say that America is the single greatest threat to humanity. And the Greatest Disgrace and disservice to all life forms on earth.


    When America fights China over oil and resources the U.S. will have to come up with something else besides 'religion' to explain away their addiction of usurping. I wonder to myself if the only the Native Indian Americans were Christians to begin with they might not have suffered their ultimate fate??? hmmm....

    Religion is really not even the issue here at all. Your missing the real point. We [U.S.] are like the drug dealers who got these poor people into this hellhole and mess in the first place, and then we blame them for their condition. Wake up America! If you don't, [and I know you won't] peak oil will be your alarm clock that you can't shut off.

    Still no believe?

    Maybe you say since I live in American I should just shut up and stop complaining. Well, I have but this to say to you:

    again, your argument that just because I live here in America I should shut up and stop complaining is [b]hypocritical.

    When the Chinese government tells its own people the same thing, somehow the US WHEEL OF HYPOCRISY will intervene and starting bitching at Hu for not giving enough 'civil right' to the Chinese people.

    Since when did the US GOV care about Chinese people? Last time I checked they very bitched about the trade imbalance and China’s growing oil demands. If they [US] are caring they sure as hell aren’t showing it by their actions.


    You still denial?

    Have you heard of Operation Northwood’s? If not I encourage you to do some research of it online or at a library. America Northwood’s was America’s EVIL PLAN to bomb and murder it own citizens and frame it on foreign nations in order to get ‘justification’ for an unpopular war. And this is just what is make public, your government is clearly capable of doing must more evil considering all the secret classified documents of plans such as Operation Northwoods that will never be make public.

    And for those of you not in the know, there is ample irresputable evident that on 9/11 World Trade Center Building 7 was bombed by your own US Government. WTC 7 collapsed in a precisely vertical fashion. First, no building collapses exactly vertically unless it was engineered and rigged to do so. Second, WTC was a steel building. And no steel building has ever collapsed due to minimal fire. What is the motive you ask? Your EVIL EMPIRE propaganda machine loves drama. Americans citizens are the mob, and George Walker Commodus will use fear and drama to feeds American’s people to the lions (CEO Government, Big Business, Military-Industrial Complex) and you will THANK HIM FOR IT.

    Isn’t that what you are doing now?

    What, still denial?

    Then let me give you this cool movie clip, perhaps it can enlighten you of reality.

    http://festival.sundance.org/2006/wa...2&category=DOC

    Best,

    Bo Chen

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1