realdemigod
Board Regular
- Joined
- Aug 19, 2014
- Messages
- 51
- Office Version
- 365
- Platform
- MacOS
Hello everyone,
I'm new to this forum and this is my first post. I'm a total novice when it comes to VBA programming and always took help of freely available source codes for simple tasks. For a recent exercise for my boss I wrote this following code (some amount partially taken from online).
Workbook Layout
Sheet1 - Table with rows and the identifier column BZ has the following data to be matched
ReferenceSheet - The data against which Sheet1 column BZ is matched (should be on the sheet with the name "ReferenceSheet" between B3:B18.
Sheet2 - Should be present always as this is the sheet into which the matched rows are copied
Objective. Copy all rows which have a identifier matching with the ones present in "ReferenceSheet" and paste into a new sheet ("Sheet2")
Sheet1 has a table with many rows and a column BZ which has identifier to look for a match from the "ReferenceSheet"
If there is a match, the macro copies the row and puts into Sheet2
This is the macro code
Problem
The code is working ok as it copies some rows with matched identifiers but it's missing out few even though the comparison strings are exactly the same. The three strings from "Sheet1" match with the ones in "ReferenceSheet" but are not copied to "Sheet2" when I run the macro.
ANZ-NATIONALAUSTRALIABANK
ANZ-QantasAirwaysLimited
ANZ-WESTPACBANKINGCORPORATIO
I don't know where I'm going wrong and have been breaking my head for days . So I decided to seek expertise help. I'm unable to share the xlsm file else would have gladly shared.
I would really appreciate if anyone could help me with this.
Apology in case I violated any rule.
Thanks,
realdemigod
I'm new to this forum and this is my first post. I'm a total novice when it comes to VBA programming and always took help of freely available source codes for simple tasks. For a recent exercise for my boss I wrote this following code (some amount partially taken from online).
Workbook Layout
Sheet1 - Table with rows and the identifier column BZ has the following data to be matched
Code:
[I]ANZ-CATHOLICCHURCHINSURANCES[/I]
[I]ANZ-PLUMBERS'SUPPLIESCO-OPER[/I]
[I]ANZ-BJBALLNZLTD[/I]
[I]ANZ-PACIFICHYDROLIMITED[/I]
[I]ANZ-NZSAFETYLTD[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-DEPARTMENTOFDEFENCE[/I]
[I]ANZ-AUSTRALIANFOOTBALLLEAGUE[/I]
[I]ANZ-ANZBANKINGGROUPLIMITED[/I]
[I]ANZ-AUSTRALIAPOST[/I]
[I]ANZ-NSWBUSINESSLINKPTYLIMITE[/I]
[I]ANZ-AUSTRALIAANDNEWZEALAND[/I]
[I]ANZ-MONASHUNIVERSITY[/I]
[I]ANZ-ASSOCIATEDRETAILERSLTD[/I]
[I]ANZ-BAYCORPNZLIMITED[/I]
[I]ANZ-NSWDEPTOFEDUCATION&[/I]
[I]ANZ-ENERGYAUSTRALIASERVICESP[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-DEPARTMENTOFHEALTH[/I]
[I]ANZ-TELSTRACORPORATION[/I]
[I]ANZ-TELSTRACORPORATION[/I]
[I]ANZ-COLONIALFIRSTSTATE[/I]
[I]ANZ-CAPITALCOASTHEALTHLIMITE[/I]
[I]ANZ-AUSTRALIANANDNEWZEALAND[/I]
[I]ANZ-AUSTRALIAPOST[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-WILEY&COPTYLIMITED[/I]
[I]ANZ-STATESTREETAUSTRALIALTD[/I]
[I]ANZ-ANZBANKINGGROUPLIMITED[/I]
[I]ANZ-DEPARTMENTOFDEFENCE[/I]
[I]ANZ-DEPARTMENTOFDEFENCE[/I]
[I]ANZ-REFININGNZ[/I]
[I]ANZ-SINGTELOPTUSPTYLIMITED[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-DOWNEREDILIMITED[/I]
[I]ANZ-2DEGREES[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-AUSTRALIANGOVERNMENT[/I]
[I]ANZ-PENLEIGHANDESSENDONGRAMM[/I]
[I]ANZ-NEWS[/I]
[I]ANZ-MERCKSHARP&DOHME(AUST)P/[/I]
[I]ANZ-AUSTRALIANBROADCASTING[/I]
[I]ANZ-AUSTRALIAPOST[/I]
[I]ANZ-BENDIGOBANKANDADELAIDEBA[/I]
[I]ANZ-TWEEDSHIRECOUNCIL[/I]
[I]ANZ-GOULBURNCITYCOUNCIL[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-BPAUSTRALIAPTYLTD[/I]
[I]ANZ-CSCAUSTRALIAPTYLTD[/I]
[I]ANZ-MORELANDCITYCOUNCIL[/I]
[I]ANZ-BENDIGOBANKANDADELAIDEBA[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-RESERVEBANKOFAUSTRALIA[/I]
[I]ANZ-OFFICEMAXAUSTRALIALIMITE[/I]
[I]ANZ-FUJIXEROXDOCUMENTMANAGEM[/I]
[I]ANZ-ENERGYAUSTRALIAPTYLIMITE[/I]
[I]ANZ-INDOAUSTINVESTMENTSLIMIT[/I]
[I]ANZ-GUDAUTOMOTIVEPTYLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-FARMERSTRADINGCOMPANYLIM[/I]
[I]ANZ-MACQUARIEGROUPSERVICES[/I]
[I]ANZ-NOSSALHIGHSCHOOL[/I]
[I]ANZ-DEPARTMENTOFTRANSPORT,[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-BRISBANECATHOLICEDUCATIO[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-FLINDERSUNIVERSITY[/I]
[I]ANZ-DEPARTMENTOFFINANCE&[/I]
[I]ANZ-MARSHPTYLTD[/I]
[I]ANZ-SUNCORPCORPORATESERVICES[/I]
[I]ANZ-NSW[/I]
[I]ANZ-NSW[/I]
[I]ANZ-RICHMONDVALLEYCOUNCIL[/I]
[I]ANZ-FRIENDLYSOCIETYMEDICAL[/I]
[I]ANZ-BPAUSTRALIAPTYLTD[/I]
[I]ANZ-BPAUSTRALIAPTYLTD[/I]
[I]ANZ-BPAUSTRALIAPTYLTD[/I]
[I]ANZ-TollCorporateIT[/I]
[I]ANZ-LOGICAMMSLIMITED[/I]
[I]ANZ-MONASHUNIVERSITY[/I]
[I]ANZ-CENTRELINK[/I]
[I]ANZ-UBSAG,AUSTRALIABRANCH[/I]
[I]ANZ-OFFICEMAXAUSTRALIALIMITE[/I]
[I]ANZ-NEWS[/I]
[I]ANZ-GLADSTONEAREAWATERBOARD[/I]
[I]ANZ-THETRUSTEEFOR[/I]
[I]ANZ-NSWDEPTOFEDUCATION&[/I]
[I]ANZ-OFFICEMAXAUSTRALIALIMITE[/I]
[I]ANZ-LGSSPTYLIMITED[/I]
[I]ANZ-COMMONWEALTHDEPARTMENTOF[/I]
[I]ANZ-AMERICANEXPRESSAUSTRALIA[/I]
[I]ANZ-AUSTRALIANANDNEWZEALAND[/I]
[I]ANZ-WESTPAC-ABG[/I]
[I]ANZ-IBMGLOBALSERVICES[/I]
[I]ANZ-CenITexDTF[/I]
[I]ANZ-UNIVERSITYOFAUCKLAND[/I]
[I]ANZ-DELOITTETOUCHETOHMATSU[/I]
[I]ANZ-MYERPTYLTD[/I]
[I]ANZ-ROYALAUTOMOBILECLUBOFVIC[/I]
[I]ANZ-COLLIERSINTERNATIONAL(NS[/I]
[I]ANZ-NATIONALAUSTRALIABANKLTD[/I]
[I]ANZ-DAVIDJONESLIMITED[/I]
[I]ANZ-DepartmentofPlanningTran[/I]
[I]ANZ-MACQUARIEGROUPSERVICES[/I]
[I]ANZ-DEAKINUNIVERSITY[/I]
[I]ANZ-WESTPACBANKING[/I]
[I]ANZ-BGINTERNATIONALLIMITED[/I]
[I]ANZ-SUNCORPCORPORATESERVICES[/I]
[I]ANZ-NATIONALAUSTRALIABANKLTD[/I]
[I]ANZ-ASUREQUALITYLIMITED[/I]
[I]ANZ-SUNCORPCORPORATESERVICES[/I]
[I]ANZ-InterfaceFLOR[/I]
[I]ANZ-InterfaceFLOR[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-SUNCORPCORPORATESERVICES[/I]
[I]ANZ-DEPARTMENTOFHUMANSERVICE[/I]
[I]ANZ-PETERMACCALLUMCANCER[/I]
[I]ANZ-DEUTSCHEBANK[/I]
[I]ANZ-IPSWICHCITY[/I]
[I]ANZ-AUST&NEWZEALANDCOLLEGEOF[/I]
[I]ANZ-CRIMTRAC[/I]
[I]ANZ-BHPBILLITONGROUPOPERATIO[/I]
[I]ANZ-ACCOAUSTRALIAPTYLIMITED[/I]
[I]ANZ-CENTRELINK[/I]
[I]ANZ-AMCORLTD[/I]
[I]ANZ-EZIDEBITPTYLTD[/I]
[I]ANZ-COSTA[/I]
[I]ANZ-DATA#3[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-DIISRTE[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-FUJIXEROXAUSTRALIAPTYLTD[/I]
[I]ANZ-IOOFLTD[/I]
[I]ANZ-KAZGROUPPTYLTD[/I]
[I]ANZ-IMBLIMITED[/I]
[I]ANZ-NSWBUSINESSLINKPTYLIMITE[/I]
[I]ANZ-INTERNATIONALTRUCKS[/I]
[I]ANZ-KAZGROUPPTYLTD[/I]
[I]ANZ-OFFISPTYLIMITED[/I]
[I]ANZ-MUIRELECTRICALCOPTYLIMIT[/I]
[I]ANZ-WILLIAMADAMSPTYLTD[/I]
[I]ANZ-NSWPOLICEFORCE[/I]
[I]ANZ-RebelSportLimited[/I]
[I]ANZ-SPRUSON&FERGUSONUNITTRUS[/I]
[I]ANZ-TOYS'R'US(AUSTRALIA)PTYL[/I]
[I]ANZ-UNITEDENERGYDISTRIBUTION[/I]
[I]ANZ-TELECOMNZLTD[/I]
[I]ANZ-TELSTRACORPORATION[/I]
[I]ANZ-ULTRADATAAUSTRALIAPTYLTD[/I]
[I]ANZ-HEALTHSUPPORTSERVICES[/I]
[I]ANZ-MCDONALD'SAUSTRALIALIMIT[/I]
[I]ANZ-RICOHAUSTRALIAPTYLTD[/I]
[I]ANZ-SUPERPARTNERSPTYLTD[/I]
[I]ANZ-AUSTRALIANPAYMENTSCLEARI[/I]
[I]ANZ-NSW[/I]
[I]ANZ-NSWBUSINESSLINKPTYLIMITE[/I]
[I]ANZ-CSIRO[/I]
[I]ANZ-THESYSTEMWORKSPTYLIMITED[/I]
[I]ANZ-BANKWEST[/I]
[I]ANZ-CocaColaAmatil[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-SINGTELOPTUSPTYLIMITED[/I]
[I]ANZ-IKEADISTRIBUTIONSERVICES[/I]
[I]ANZ-EROADLIMITED[/I]
[I]ANZ-DEPARTMENTOFFINANCEAND[/I]
[I]ANZ-NEWCRESTMININGLIMITED[/I]
[I]ANZ-CSIRO[/I]
[I]ANZ-NZLOTTERIESCOMMISSION[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-MSSSECURITYGROUPPTYLTD[/I]
[I]ANZ-AIAAUSTRALIALIMITED[/I]
[I]ANZ-VentyxPtyLtd[/I]
[I]ANZ-UNIVERSITYOFTECHNOLOGY[/I]
[I]ANZ-SCHWEPPESAUSTRALIAPTY[/I]
[I]ANZ-AGLENERGYLIMITED[/I]
[I]ANZ-AGRESEARCH[/I]
[I]ANZ-SCHWEPPESAUSTRALIAPTY[/I]
[I]ANZ-FINWAREAUSTRALIAPTYLTD[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-ILUKARESOURCESLIMITED[/I]
[I]ANZ-JAMESCOOKUNIVERSITY[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-NEWZEALANDPOLICE[/I]
[I]ANZ-DEPTOFEMPLOYMENT&WORKPLA[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-BENDIGOCOMMUNITYTELCO[/I]
[I]ANZ-PILLARADMINISTRATION[/I]
[I]ANZ-PILLARADMINISTRATION[/I]
[I]ANZ-RioTinto[/I]
[I]ANZ-NSWBUSINESSLINKPTYLIMITE[/I]
[I]ANZ-COLESMYERLIMITED[/I]
[I]ANZ-MODERNBAKINGCOMPANYPTYLT[/I]
[I]ANZ-ANIMALLOGIC[/I]
[I]ANZ-SUNNYQUEENLIMITED[/I]
[I]ANZ-WESFARMERSLIMITED[/I]
[I]ANZ-THECHERMSIDE&DISTRICT[/I]
[I]ANZ-AMPSERVICESLIMITED[/I]
[I]ANZ-SUNNYQUEENLIMITED[/I]
[I]ANZ-SIGMACOMPANYLTD[/I]
[I]ANZ-WESFARMERSLIMITED[/I]
[I]ANZ-GreenButton[/I]
[I]ANZ-THEMYEREMPORIUMLIMITED[/I]
[I]ANZ-EnlightenDesigns[/I]
[I]ANZ-WEBCENTRALPTYLIMITED[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-OPTUSSYSTEMS[/I]
[I]ANZ-MinistryofSocialDevelopm[/I]
[I]ANZ-IOOFLTD[/I]
[I]ANZ-AMPLIMITED[/I]
[I]ANZ-DATACOMSYSTEMSS.A.PTYLTD[/I]
[I]ANZ-INSTITUTEOFGEOLOGICALAND[/I]
[I]ANZ-JELD-WENOFAUSTRALIAPTY[/I]
[I]ANZ-METCASHTRADINGLIMITED[/I]
[I]ANZ-MYERPTYLTD[/I]
[I]ANZ-AUSTRALIANCUSTOMSANDBORD[/I]
[I]ANZ-SCHWEPPESAUSTRALIAPTY[/I]
[I]ANZ-CNHAUSTRALIAPTYLTD[/I]
[I]ANZ-CNHAUSTRALIAPTYLTD[/I]
[I]ANZ-MCKILLOPFAMILYSERVICES[/I]
[I]ANZ-NSWDEPARTMENTOFCOMMERCE[/I]
[I]ANZ-INSURANCEAUSTRALIALIMITE[/I]
[I]ANZ-WACOKWIKFORMLIMITED[/I]
[I]ANZ-NEWZEALANDRACINGBOARD[/I]
[I]ANZ-THEHOSPITALSCONTRIBUTION[/I]
[I]ANZ-ALL-TASKSCOMPUTERSERVICE[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-DEPARTMENTOFJUSTICE[/I]
[I]ANZ-TABCORPHOLDINGSLIMITED[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-MCDONALD'SAUSTRALIALIMIT[/I]
[I]ANZ-IRONSTONECAPITALADVISORY[/I]
[I]ANZ-NZLOTTERIESCOMMISSION[/I]
[I]ANZ-BROWNBROTHERSMILAWAVINEY[/I]
[I]ANZ-HUMECITYCOUNCIL[/I]
[I]ANZ-AUSTRALIANANDNEWZEALAND[/I]
[I]ANZ-SantosLimted[/I]
[I]ANZ-SOUTHERNCROSSCOMPUTER[/I]
[I]ANZ-SIMPLOTAUSTRALIAPTYLTD[/I]
[I]ANZ-StVincents&MaterHealthSy[/I]
[I]ANZ-RISINGSUNPICTURES[/I]
[I]ANZ-StVincents&MaterHealthSy[/I]
[I]ANZ-ASGGROUPLIMITED[/I]
[I]ANZ-ATLASSIANPTYLTD[/I]
[I]ANZ-HBFHEALTHFUNDSINCORPORAT[/I]
[I]ANZ-EDITHCOWANUNIVERSITY[/I]
[I]ANZ-ORCONLIMITED[/I]
[I]ANZ-SANTOSLIMITED[/I]
[I]ANZ-HARBOURITPTYLIMITED[/I]
[I]ANZ-WORKCOVERAUTHORITY[/I]
[I]ANZ-THEUNIVERSITYOFMELBOURNE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-HALLMARKCARDSAUSTRALIALT[/I]
[I]ANZ-VEDAADVANTAGELIMITED[/I]
[I]ANZ-MYERPTYLTD[/I]
[I]ANZ-HYUNDAIMOTORCOMPANY[/I]
[I]ANZ-MYERPTYLTD[/I]
[I]ANZ-CertusSolutions[/I]
[I]ANZ-SUNCORPCORPORATESERVICES[/I]
[I]ANZ-BAYCORPNZLIMITED[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-SYDNEYAIRPORTS[/I]
[I]ANZ-DEPARTMENTOFJUSTICE[/I]
[I]ANZ-DEPARTMENTOFJUSTICE[/I]
[I]ANZ-DEPARTMENTOFJUSTICE[/I]
[I]ANZ-OPENUNIVERSITIESAUSTRALI[/I]
[I]ANZ-TELECOMNEWZEALANDLIMITED[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-TASMANIANPERPETUALTRUSTE[/I]
[I]ANZ-UNIVERSITYOFCANBERRA[/I]
[I]ANZ-SUPERPARTNERSPTYLTD[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-ASBBANKLTD[/I]
[I]ANZ-UniversityofWesternSydne[/I]
[I]ANZ-QBEITSERVICESPTYLIMITED[/I]
[I]ANZ-INTACTGROUP[/I]
[I]ANZ-AGCOAUSTRALIALIMITED[/I]
[I]ANZ-AUSTRALIANSECURITIES&[/I]
[I]ANZ-AUSTRALIANADMINSERVICESP[/I]
[I]ANZ-AL-KOINTERNATIONAL[/I]
[I]ANZ-BANKWEST[/I]
[I]ANZ-AUSTRALIANADMINSERVICESP[/I]
[I]ANZ-ACCOLADEWINESAUSTRALIA[/I]
[I]ANZ-ANZBANKINGGROUPLIMITED[/I]
[I]ANZ-BIG4HOLIDAYPARKSOF[/I]
[I]ANZ-O-IASIAPACIFIC[/I]
[I]ANZ-ALLIANZAUSTRALIALIMITED[/I]
[I]ANZ-AUSTRALIANSECURITIES&[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-COLESSUPERMARKETSAUSTRAL[/I]
[I]ANZ-CSCAUSTRALIAPTYLTD[/I]
[I]ANZ-AUSTRALIANADMINSERVICESP[/I]
[I]ANZ-APISECURITYPTYLIMITED[/I]
[I]ANZ-BANKWEST[/I]
[I]ANZ-CENTRELINK[/I]
[I]ANZ-COLESSUPERMARKETSAUSTRAL[/I]
[I]ANZ-CSCAUSTRALIAPTYLTD[/I]
[I]ANZ-ACFSÌAUSTRALIANCONTAINER[/I]
[I]ANZ-AUSCLADGROUPOFCOMPANIES[/I]
[I]ANZ-BROWNBROTHERSENGINEERS[/I]
[I]ANZ-CIGWELDPTYLTD[/I]
[I]ANZ-DAVIDJONESLIMITED[/I]
[I]ANZ-AMTRADEINTERNATIONALPTYL[/I]
[I]ANZ-BANKWEST[/I]
[I]ANZ-CENTRELINK[/I]
[I]ANZ-COLEAMBALLYIRRIGATION[/I]
[I]ANZ-DATA#3[/I]
[I]ANZ-SPORTSINVESTMENTSAUSTP/L[/I]
[I]ANZ-BANKWEST[/I]
[I]ANZ-BUDERIMGINGERLIMITED[/I]
[I]ANZ-COMPUTERMERCHANTSPTYLTD[/I]
[I]ANZ-CSCAUSTRALIAPTYLTD[/I]
[I]ANZ-FAIRFIELDCITYCOUNCIL[/I]
[I]ANZ-HEARTLANDMOTORSPTYLIMITE[/I]
[I]ANZ-NSWBOARDOFSTUDIES[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-COLESSUPERMARKETSAUSTRAL[/I]
[I]ANZ-CSCAUSTRALIAPTYLTD[/I]
[I]ANZ-ENGENCOLIMITED[/I]
[I]ANZ-FUJIFILMAUSTRALIAPTYLTD[/I]
[I]ANZ-CHPCONSULTINGAUSTRALIAPT[/I]
[I]ANZ-FIRSTDATARESOURCES[/I]
[I]ANZ-HONDAAUSTMOTORCYCLE&POWE[/I]
[I]ANZ-CARDLINKSERVICES[/I]
[I]ANZ-CLUBMARINELIMITED[/I]
[I]ANZ-CO-OPERATIVEBULKHANDLING[/I]
[I]ANZ-FUJIXEROXAUSTRALIAPTYLTD[/I]
[I]ANZ-HEALTHSCOPELIMITED[/I]
[I]ANZ-GUNZDENTALPTYLTD[/I]
[I]ANZ-FRONTIERSOFTWAREPTYLTD[/I]
[I]ANZ-HAZELLBROS[/I]
[I]ANZ-INSURANCEAUSTRALIALIMITE[/I]
[I]ANZ-MERCEDES-BENZAUSTRALIA[/I]
[I]ANZ-METLIFEINSURANCELIMITED[/I]
[I]ANZ-METALMANUFACTURESLIMITED[/I]
[I]ANZ-MILNEAGRIGROUPPTYLTD[/I]
[I]ANZ-METCASHTRADINGLIMITED[/I]
[I]ANZ-NAMOICOTTONPTYLIMITED[/I]
[I]ANZ-NEWCASTLEPERMANENTBUILDI[/I]
[I]ANZ-NEWCASTLEPERMANENTBUILDI[/I]
[I]ANZ-NGKSPARKPLUGPTYLTD[/I]
[I]ANZ-NEWS[/I]
[I]ANZ-INTEGRATEDSOLUTIONSQLD[/I]
[I]ANZ-OFFISPTYLIMITED[/I]
[I]ANZ-OneSteelTradingPtyLtd[/I]
[I]ANZ-SINGTELOPTUSPTYLIMITED[/I]
[I]ANZ-ORICAAUSTRALIAPTYLIMITED[/I]
[I]ANZ-PAPERLINXLIMITED[/I]
[I]ANZ-PHILIPSELECTRONICSAUSTRA[/I]
[I]ANZ-PATTIESFOODS[/I]
[I]ANZ-PITNEYBOWESAUSTRALIAPTYL[/I]
[I]ANZ-PRIMURSYSTEMS&RESOURCESP[/I]
[I]ANZ-PICKETTCOMPUTERSERVICES[/I]
[I]ANZ-SUTTONSMOTORSMANAGEMENT[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-RETAILADVENTURESPTYLIMIT[/I]
[I]ANZ-SILVERFERNCOMPUTERSPTYLT[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-REDENERGYLIMITED[/I]
[I]ANZ-ISUZUAUSTRALIALIMITED[/I]
[I]ANZ-SCEGROUPPTYLIMITED[/I]
[I]ANZ-SWINBURNEUNIVERSITY[/I]
[I]ANZ-MURISHUNPTYLTD[/I]
[I]ANZ-RGAREINSURANCECOMPANYOF[/I]
[I]ANZ-SIGMACOMPANYLIMITED[/I]
[I]ANZ-TABCORPHOLDINGSLIMITED[/I]
[I]ANZ-TRAVELEXLIMITED[/I]
[I]ANZ-W.EAGLESPLUMBINGSUPPLIES[/I]
[I]ANZ-RewardDistributionGroup[/I]
[I]ANZ-SHRIROAUSTRALIAPTYLIMITE[/I]
[I]ANZ-SOMMER&STAFFCONSTRUCTION[/I]
[I]ANZ-TRANSACTCAPITAL[/I]
[I]ANZ-ROADSCORPORATION[/I]
[I]ANZ-WESFARMERSINSURANCE[/I]
[I]ANZ-PRUDENTIALINVESTMENTCOMP[/I]
[I]ANZ-SCANIAAUSTRALIAPTYLIMITE[/I]
[I]ANZ-SITAAUSTRALIAPTYLTD[/I]
[I]ANZ-SUPERRETAILGROUPSERVICES[/I]
[I]ANZ-VODAFONEPTYLTD[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-KANECONSTRUCTIONSPTYLTD[/I]
[I]ANZ-WESTERNPOWER[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-SAMIOSTYRES[/I]
[I]ANZ-SINGTELOPTUSPTYLIMITED[/I]
[I]ANZ-STRANDBAGSGROUPPTYLIMITE[/I]
[I]ANZ-VIVACITYENGINEERINGPTYLT[/I]
[I]ANZ-WILSONPARKINGAUSTRALIA19[/I]
[I]ANZ-SWINBURNEUNIVERSITY[/I]
[I]ANZ-LOTTERIESCOMMISSIONOFWA[/I]
[I]ANZ-WHISPIRAUSTRALIAPTYLTD[/I]
[I]ANZ-KOMATSUFORKLIFTAUSTRALIA[/I]
[I]ANZ-WEIDMULLERPTYLTD[/I]
[I]ANZ-BAULDERSTONE[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-WHITEINTERNATIONALPTYLTD[/I]
[I]ANZ-MARTIN-BROWERAUSTRALIAPT[/I]
[I]ANZ-RAVENPRODUCTSPTY.LIMITED[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-KMARTAUSTRALIALTD[/I]
[I]ANZ-CSENERGYLIMITED[/I]
[I]ANZ-RICOHAUSTRALIAPTYLTD[/I]
[I]ANZ-SUSSANCORPORATION(AUST)L[/I]
[I]ANZ-CLONARDCOLLEGE[/I]
[I]ANZ-VOYAGENEWZEALANDLIMITED[/I]
[I]ANZ-DEPARTMENTOFTRADE&[/I]
[I]ANZ-OFFICEOFPARLIAMENTARY[/I]
[I]ANZ-DepartmentofPremierandCa[/I]
[I]ANZ-DEAKINUNIVERSITY[/I]
[I]ANZ-SingTelOptusPtyLtd[/I]
[I]ANZ-SANFORDLTD[/I]
[I]ANZ-SUNCORPCORPORATESERVICES[/I]
[I]ANZ-ROYAL&SUNALLIANCEINSURAN[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-ABIGROUPLIMITED[/I]
[I]ANZ-VANGUARDINVESTMENTSAUSTR[/I]
[I]ANZ-RAILWAYSCREDITUNIONLIMIT[/I]
[I]ANZ-UGLServicesPtyLtd[/I]
[I]ANZ-BANKWEST[/I]
[I]ANZ-DEPARTMENTOFSTATE[/I]
[I]ANZ-CREDITUNIONAUSTRALIALIMI[/I]
[I]ANZ-ORIGINITLIMITED[/I]
[I]ANZ-OFFICESWORKSSUPERSTORESP[/I]
[I]ANZ-BENDIGOBANKANDADELAIDEBA[/I]
[I]ANZ-EXEGOPTYLIMITED[/I]
[I]ANZ-SMITH&NEPHEW(AUST)PTYLTD[/I]
[I]ANZ-ColesLtd[/I]
[I]ANZ-ABNAMROCLEARINGSYDNEYPTY[/I]
[I]ANZ-TELSTRACORPORATION[/I]
[I]ANZ-CAPTTERRITORYHEALTHCOMM[/I]
[I]ANZ-CITEC[/I]
[I]ANZ-COCA-COLAAMATILLIMITED[/I]
[I]ANZ-CocaColaAmatil[/I]
[I]ANZ-TABCORPHOLDINGSLIMITED[/I]
[I]ANZ-IMAGINEITSOLUTIONSPTY[/I]
[I]ANZ-NATIONALAUSTRALIABANKLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-ALLIANZAUSTRALIASERVICES[/I]
[I]ANZ-BENDIGOCOMMUNITYTELCO[/I]
[I]ANZ-NEWSCORPORATIONNOMINEESP[/I]
[I]ANZ-WESTONCEREALINDUSTRIES[/I]
[I]ANZ-MASSEYUNIVERSITYAT[/I]
[I]ANZ-STATESTREETAUSTRALIALTD[/I]
[I]ANZ-RWWA[/I]
[I]ANZ-AUSTRALIANNETWORKS[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-SUPERRETAILGROUPSERVICES[/I]
[I]ANZ-PARKAVENUEPTYLTD[/I]
[I]ANZ-SPECIALIZEDCONTAINER[/I]
[I]ANZ-TELSTRACORPORATION[/I]
[I]ANZ-SUNCORPCORPORATESERVICES[/I]
[I]ANZ-LATROBEUNIVERSITY[/I]
[I]ANZ-DEPARTMENTOFDEFENCE[/I]
[I]ANZ-DEPARTMENTOFJUSTICE[/I]
[I]ANZ-THEORDEROFSAINTJOHN[/I]
[I]ANZ-CICAUSTRALIALIMITED[/I]
[I]ANZ-BUPAAUSTRALIAPTYLIMITED[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-DEPARTMENTOFHEALTH[/I]
[I]ANZ-StellarLibraryGPLimited[/I]
[I]ANZ-CKIUTILITIESDEVELOPMENTL[/I]
[I]ANZ-COMMONWEALTHDEPARTMENTOF[/I]
[I]ANZ-THELANGHAMHOTELAUCKLAND[/I]
[I]ANZ-SUNCORPGROUPLIMITED[/I]
[I]ANZ-FUJIXEROXDOCUMENTMANAGEM[/I]
[I]ANZ-ROYALAUTOMOBILECLUBOF[/I]
[I]ANZ-REDENERGYLIMITED[/I]
[I]ANZ-HUMECITYCOUNCIL[/I]
[I]ANZ-FUJIXEROXDOCUMENTMANAGEM[/I]
[I]ANZ-REDENERGYLIMITED[/I]
[I]ANZ-METLIFEINSURANCELIMITED[/I]
[I]ANZ-USGBORALBUILDINGPRODUCTS[/I]
[I]ANZ-WorkGroupResourcesNZ[/I]
[I]ANZ-MELBOURNEWATERCORPORATIO[/I]
[I]ANZ-VECTORLIMITED[/I]
[I]ANZ-WESTPACNEWZEALANDLIMITED[/I]
[I]ANZ-MikiproLimited[/I]
[I]ANZ-WESTPACNEWZEALANDLIMITED[/I]
[I]ANZ-CTBusinessSolutions[/I]
[I]ANZ-TASGASCOPTY.LTD[/I]
[I]ANZ-ASBBANKLTD[/I]
[I]ANZ-TRANSGRID[/I]
[I]ANZ-UBSAG,AUSTRALIABRANCH[/I]
[I]ANZ-AUSTRALIANPAYMENTSCLEARI[/I]
[I]ANZ-THEHOLLARDINSURANCECOMPA[/I]
[I]ANZ-ConnectNet[/I]
[I]ANZ-NATIONALAUSTRALIABANKLTD[/I]
[I]ANZ-SCHWEPPESAUSTRALIAPTY[/I]
[I]ANZ-NATIONALCOMMUNICATIONS[/I]
[I]ANZ-NAPIERCOMPUTERSYSTEMSLIM[/I]
[I]ANZ-WESTERNPOWER[/I]
[I]ANZ-NATIONALAUSTRALIABANKLTD[/I]
[I]ANZ-ACITLimited[/I]
[I]ANZ-RevenueSA[/I]
[I]ANZ-WestpacBanking[/I]
[I]ANZ-JAGUARLANDROVERAUSTRALIA[/I]
[I]ANZ-SUSSANCORPORATION(AUST)L[/I]
[I]ANZ-CAULFIELDGRAMMARSCHOOL[/I]
[I]ANZ-SINGTELOPTUSPTYLIMITED[/I]
[I]ANZ-SUNCORPGROUPLIMITED[/I]
[I]ANZ-CITYOFBOROONDARA[/I]
[I]ANZ-CITYOFBOROONDARA[/I]
[I]ANZ-SUNCORPCORPORATESERVICES[/I]
[I]ANZ-DEPARTMENTOFFINANCEAND[/I]
[I]ANZ-AUSTRALIANGRANDPRIXACCOM[/I]
[I]ANZ-TELSTRACORPORATION[/I]
[I]ANZ-BENDIGOANDADELAIDEBANKLI[/I]
[I]ANZ-O2NETWORKSPTYLTD[/I]
[I]ANZ-NEWCRESTMININGLIMITED[/I]
[I]ANZ-VICTORIANWORKCOVERAUTHOR[/I]
[I]ANZ-VICTORIANWORKCOVERAUTHOR[/I]
[I]ANZ-SUNCORPGROUPLIMITED[/I]
[I]ANZ-SUSSANCORPPROPERTYDIVISI[/I]
[I]ANZ-RABOBANKAUSTRALIALIMITED[/I]
[I]ANZ-AustraliaandNewZealandBa[/I]
[I]ANZ-DAYCOAUSTRALIAPTYLIMITED[/I]
[I]ANZ-SCHWEPPESAUSTRALIAPTY[/I]
[I]ANZ-COMPUTERMERCHANTSPTYLTD[/I]
[I]ANZ-PERFORMANCEITCONSULTING[/I]
[I]ANZ-OTSITConsultingPtyLtd[/I]
[I]ANZ-KIWIRAILLIMITED[/I]
[I]ANZ-ALCOAOFAUSTRALIALIMITED[/I]
[I]ANZ-AUSGRID[/I]
[I]ANZ-SUNDATAMARKETING[/I]
[I]ANZ-BENDIGOANDADELAIDEBANKLI[/I]
[I]ANZ-PrecisionAdministrationS[/I]
[I]ANZ-ALCOAOFAUSTRALIALIMITED[/I]
[I]ANZ-ALCOAOFAUSTRALIALIMITED[/I]
[I]ANZ-ALCOAOFAUSTRALIALIMITED[/I]
[I]ANZ-SUNCORPGROUPLIMITED[/I]
[I]ANZ-COMMONWEALTHBANK[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-AUCKLANDINTERNATIONALAIR[/I]
[I]ANZ-STEEL&TUBEHOLDINGSLTD[/I]
[I]ANZ-MELBOURNE&OLYMPICPARKS[/I]
[I]ANZ-NATIONALAUSTRALIABANKLTD[/I]
[I]ANZ-UNIVERSITYOFNEWSOUTHWALE[/I]
[I]ANZ-CAULFIELDGRAMMARSCHOOL[/I]
[I]ANZ-VODAFONEHUTCHISONAUSTRAL[/I]
[I]ANZ-NATIONALAUSTRALIABANKLTD[/I]
[I]ANZ-RACINGANDWAGERINGWESTERN[/I]
[I]ANZ-THERMOFISHERSCIENTIFICNE[/I]
[I]ANZ-MARIST-SIONCOLLEGE[/I]
[I]ANZ-DEPARTMENTOFTRANSPORT[/I]
[I]ANZ-LULULEMONATHLETICAAUSTRA[/I]
[I]ANZ-REDENERGYLIMITED[/I]
[I]ANZ-TOURISMHOLDINGSLTD[/I]
[I]ANZ-CERTUSSOLUTIONS[/I]
[I]ANZ-BHPBILLITONIRONOREPTYLTD[/I]
[I]ANZ-OFFICEOFTHECLERK[/I]
[I]ANZ-AUSGRID[/I]
[I]ANZ-VICTORIANWORKCOVERAUTHOR[/I]
[I]ANZ-VICTORIANWORKCOVERAUTHOR[/I]
[I]ANZ-HBFHEALTHFUNDSINCORPORAT[/I]
[I]ANZ-WESTPACNEWZEALANDLIMITED[/I]
[I]ANZ-WESTPACNEWZEALANDLIMITED[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-SYDNEYWATERCORPORATION[/I]
[I]ANZ-USGBORALBUILDINGPRODUCTS[/I]
[I]ANZ-DEPARTMENTOFJUSTICE[/I]
[I]ANZ-PRONTOSOFTWARELIMITED[/I]
[I]ANZ-ALFREDHEALTH[/I]
[I]ANZ-DEPARTMENTOFJUSTICE[/I]
[I]ANZ-AustralianSuper[/I]
[I]ANZ-HBFHEALTHFUNDSINCORPORAT[/I]
[I]ANZ-AustralianSuper[/I]
[I]ANZ-AUSTRALIANSUPERPTYLTD[/I]
[I]ANZ-J.P.MORGANOPERATIONS[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-J.P.MORGANOPERATIONS[/I]
[I]ANZ-WOOLWORTHSLTD[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-STVINCENTSHOSPITAL[/I]
[I]ANZ-DULUXHOLDINGSPTYLTD[/I]
[I]ANZ-BENDIGOANDADELAIDEBANKLI[/I]
[I]ANZ-VECTORLIMITED[/I]
[I]ANZ-SCHWEPPESAUSTRALIAPTY[/I]
[I]ANZ-ECOTECHPTYLTD[/I]
[I]ANZ-NINENETWORKAUSTRALIAPTYL[/I]
[I]ANZ-DEPARTMENTOFJUSTICE[/I]
[I]ANZ-BLOCKEDFROMVIEW[/I]
[I]ANZ-CSIRO[/I]
[I]ANZ-NEWCRESTMININGLIMITED[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-AMBULANCEVICTORIA[/I]
[I]ANZ-AXEGROUPPTYLIMITED[/I]
[I]ANZ-DEPARTMENTOF[/I]
[I]ANZ-SUNCORPCORPORATESERVICES[/I]
[I]ANZ-DEPOFFOREIGNAFFAIRS&TRAD[/I]
[I]ANZ-RAILWAYSCREDITUNIONLIMIT[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-CertusSolutions[/I]
[I]ANZ-ZURICHAUSTINSURANCELTD[/I]
[I]ANZ-AUSTRALIAANDNEWZEALAND[/I]
[I]ANZ-PLANETINNOVATION[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-GENESISENERGY[/I]
[I]ANZ-SOUTHERNDHB[/I]
[I]ANZ-AUSTRALIANPAYMENTSCLEARI[/I]
[I]ANZ-Thecloud[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-MELBOURNECRICKETCLUB[/I]
[I]ANZ-SELECTHARVESTSLIMITED[/I]
[I]ANZ-DEPARTMENTOFTRANSPORT[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-THENIELSENCOMPANY(HOLDIN[/I]
[I]ANZ-AustralianHearing[/I]
[I]ANZ-AustralianBureauofStatis[/I]
[I]ANZ-VOYAGESHOTELS&RESORTSPTY[/I]
[I]ANZ-CANBERRAINSTITUTEOF[/I]
[I]ANZ-STVINCENT'SHEALTHAUSTRAL[/I]
[I]ANZ-ROYALALEXANDRAHOSPITAL[/I]
[I]ANZ-COATESHIRELIMITED[/I]
[I]ANZ-CSRLIMITED[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-ASBBANKLTD[/I]
[I]ANZ-FONTERRA[/I]
[I]ANZ-2DEGREES[/I]
[I]ANZ-UNITECINSTITUTEOFTECHNOL[/I]
[I]ANZ-ROSETTASOLUTIONSPTYLTD[/I]
[I]ANZ-INSURANCECOMMISSIONOFWA[/I]
[I]ANZ-DIRECTPAYMENTSOLUTIONSLT[/I]
[I]ANZ-NEWCRESTMININGLIMITED[/I]
[I]ANZ-AUSTRALIAANDNEWZEALAND[/I]
[I]ANZ-AIMIAPROPRIETARYLOYALTY[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-SHELLNEWZEALAND(2011)LIM[/I]
[I]ANZ-COMPUTERMERCHANTSPTYLTD[/I]
[I]ANZ-DIMENSIONDATANZLIMITED[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-CERTUSSOLUTIONSPTYLTD[/I]
[I]ANZ-ADVENTONEPTYLTD[/I]
[I]ANZ-AVNET(AUSTRALIA)PTY.LTD[/I]
[I]ANZ-NORTHERNTERRITORYOF[/I]
[I]ANZ-AUSCOMODULARPTYLIMITED[/I]
[I]ANZ-AUSTRALIANPRUDENTIAL[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-SOUTHERNCROSSCOMPUTER[/I]
[I]ANZ-WESTFIELDLTD[/I]
[I]ANZ-STATESTREETAUSTRALIALTD[/I]
[I]ANZ-SANFORDLTD[/I]
[I]ANZ-ALFREDHEALTH[/I]
[I]ANZ-AUSTRALIAPOST[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-CONCENTRIXSERVICESPTYLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-COLESMYERLIMITED[/I]
[I]ANZ-ASBBANKLTD[/I]
[I]ANZ-WESTPACTRUST[/I]
[I]ANZ-SYDNEYWATERCORPORATION[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-HUMECITYCOUNCIL[/I]
[I]ANZ-HUMECITYCOUNCIL[/I]
[I]ANZ-HUMECITYCOUNCIL[/I]
[I]ANZ-OPTUSSYSTEMS[/I]
[I]ANZ-SUNDATAMARKETING[/I]
[I]ANZ-DATA#3[/I]
[I]ANZ-AUCKLANDUNIVERSITYOFTECH[/I]
[I]ANZ-OPTUSSYSTEMSPTYLIMITED[/I]
[I]ANZ-BENDIGOBANKANDADELAIDEBA[/I]
[I]ANZ-DEPARTMENTOFHUMANSERVICE[/I]
[I]ANZ-NATIONALAUSTRALIABANK[/I]
[I]ANZ-NATIONALAUSTRALIABANKLIM[/I]
[I]ANZ-OBJECTIVECORPORATIONPTYL[/I]
[I]ANZ-NORTHQUEENSLANDBULKPORTS[/I]
[I]ANZ-NORTHQUEENSLANDBULKPORTS[/I]
[I]ANZ-OSMOTIONPTYLTD[/I]
[I]ANZ-SYDNEYWATERCORPORATION[/I]
[I]ANZ-PULSEMININGSYSTEMSPTYLTD[/I]
[I]ANZ-FUJIFILMAUSTRALIAPTYLTD[/I]
[I]ANZ-MERCURYCONSULTING[/I]
[I]ANZ-AjilonConsulting[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-AutotaskCorporation[/I]
[I]ANZ-AVNET(AUSTRALIA)PTY.LTD[/I]
[I]ANZ-SONYDADCAUSTRALIAPTY[/I]
[I]ANZ-NEWSOUTHWALESABORIGINAL[/I]
[I]ANZ-DECIPHERWORKSPTYLTD[/I]
[I]ANZ-SENATHPTYLTD[/I]
[I]ANZ-RECKITTBENCKISER(AUSTRAL[/I]
[I]ANZ-VICTORCHANGCARDIACRESEAR[/I]
[I]ANZ-THETRUSTEEFORTHEBARLOW[/I]
[I]ANZ-SELECTHARVESTSLIMITED[/I]
[I]ANZ-THENUANCEGROUPPTYLIMITED[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-SANOFIPASTEURPTYLTD[/I]
[I]ANZ-STATESTREETAUSTRALIALIMI[/I]
[I]ANZ-ADVENTONEPTYLTD[/I]
[I]ANZ-TELSTRACORPORATION[/I]
[I]ANZ-DEPARTMENTOFDEFENCE[/I]
[I]ANZ-AVAXAPTYLTD[/I]
[I]ANZ-SOUTHERNCROSSCOMPUTERS[/I]
[I]ANZ-BANKOFNEWZEALAND[/I]
[I]ANZ-SCHLUMBERGERAUSTRALIAPTY[/I]
[I]ANZ-BOXHILLINSTITUTE[/I]
[I]ANZ-QantasAirwaysLimited[/I]
[I]ANZ-MelbourneWater[/I]
[I]ANZ-THETRUSTEEFORNAROSE[/I]
[I]ANZ-MERIDIANENERGYAUSTRALIA[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-AUSCOMODULARPTYLIMITED[/I]
[I]ANZ-RICOHAUSTRALIAPTYLTD[/I]
[I]ANZ-WESTPACNEWZEALANDLIMITED[/I]
[I]ANZ-RISINGSUNPICTURES[/I]
[I]ANZ-ASBBANKLTD[/I]
[I]ANZ-CALLPLUSLIMITED[/I]
[I]ANZ-RPSAUSTRALIAEASTPTYLTD[/I]
[I]ANZ-CALLPLUSLIMITED[/I]
[I]ANZ-AVANTEI.T.PTYLTD[/I]
[I]ANZ-GREATERUNIONSCREENENTERT[/I]
[I]ANZ-ASBBANKLTD[/I]
[I]ANZ-CANONAUSTRALIA[/I]
[I]ANZ-OneSteel[/I]
[I]ANZ-THENORTHAUSTRALIANPASTOR[/I]
[I]ANZ-RICOHAUSTRALIAPTYLTD[/I]
[I]ANZ-DEPARTMENTOFFINANCE&[/I]
[I]ANZ-SANTOSLIMITED[/I]
[I]ANZ-AUSCOMODULARPTYLIMITED[/I]
[I]ANZ-MITSUBISHIMOTORSAUSTRALI[/I]
[I]ANZ-DIMENSIONDATANEWZEALANDL[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-Qantas[/I]
[I]ANZ-AUSTRALIAANDNEWZEALAND[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-RIOTINTOSHAREDSERVICESPT[/I]
[I]ANZ-DEPTOFCORRECTIVESERVICES[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-WESTONCEREALINDUSTRIES[/I]
[I]ANZ-PGSAUSTRALIAPTYLTD[/I]
[I]ANZ-WESTFIELDLTD[/I]
[I]ANZ-7ELEVENSTORESPTYLTD[/I]
[I]ANZ-ASCIANOEXECUTIVESERVICES[/I]
[I]ANZ-DELEGATSWINEESTATESLTD[/I]
[I]ANZ-RPDATALTD[/I]
[I]ANZ-OFFICEMAXAUSTRALIALIMITE[/I]
[I]ANZ-STATEEMERGENCYSERVICE(NS[/I]
[I]ANZ-KOOWEERUPSECONDARYCOLLEG[/I]
[I]ANZ-PRONTOSOFTWARELIMITED[/I]
[I]ANZ-DECIPHERWORKSPTYLTD[/I]
[I]ANZ-JEMENALIMITED[/I]
[I]ANZ-THETRUSTEEFORTHECSBAUNIT[/I]
[I]ANZ-ZODIACAUSTRALIAPTYLTD[/I]
[I]ANZ-NSWDEPTOFEDUCATION&[/I]
[I]ANZ-METCASHTRADINGLIMITED[/I]
[I]ANZ-DEPARTMENTOFFINANCEAND[/I]
[I]ANZ-WESTFIELDLTD[/I]
[I]ANZ-DAVIDJONESLIMITED[/I]
[I]ANZ-Tectrade[/I]
[I]ANZ-VOYAGENEWZEALANDLIMITED[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-NEXRIGHTPTYLTD[/I]
[I]ANZ-MARRICKVILLECOUNCIL[/I]
[I]ANZ-WESTFIELDLTD[/I]
[I]ANZ-PortlandSoftware[/I]
[I]ANZ-CSL[/I]
[I]ANZ-HBFHEALTHFUNDSINCORPORAT[/I]
[I]ANZ-NATIONALAUSTRALIABANK[/I]
[I]ANZ-DEPARTMENTOFFINANCEAND[/I]
[I]ANZ-DEPTINDUSTRYSCIENCE&RESO[/I]
[I]ANZ-HANSENTECHNOLOGIESLIMITE[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-BLUESCOPESTEELLIMITED[/I]
[I]ANZ-RayWhiteRealEstate[/I]
[I]ANZ-UBERGLOBALPTYLTDT/AS[/I]
[I]ANZ-MILNEAGRIGROUPPTYLTD[/I]
[I]ANZ-MEDIBANKPRIVATELTD[/I]
[I]ANZ-WAIRARAPADISTRICTHEALTHB[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-VODAFONENZLTD[/I]
[I]ANZ-VICTORIAUNIVERSITY[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-SCHWEPPESAUSTRALIAPTY[/I]
[I]ANZ-DeptofDefence[/I]
[I]ANZ-O-IASIAPACIFIC[/I]
[I]ANZ-SAPowerNetworks[/I]
[I]ANZ-PERKS&ASSOCIATESPTYLIMIT[/I]
[I]ANZ-INTERNATIONALTRUCKS[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-DEPARTMENTOFEDUCATION,[/I]
[I]ANZ-NESTLEAUSTRALIALIMITED[/I]
[I]ANZ-SYNTEGRITYSOLUTIONSPTYLT[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-GECAPITALFINANCEAUSTRALA[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-ABTONLINEPTYLTD[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-OFFISPTYLIMITED[/I]
[I]ANZ-SOUTHAUSTRALIANWATER[/I]
[I]ANZ-EMCGLOBALHOLDINGSCOMPANY[/I]
[I]ANZ-QBEMANAGEMENTSERVICESPTY[/I]
[I]ANZ-ROYALCHILDREN'SHOSPITAL[/I]
[I]ANZ-BANKOFQUEENSLANDLTD[/I]
[I]ANZ-COMPUTERMERCHANTSPTYLTD[/I]
[I]ANZ-DEPARTMENTOF[/I]
[I]ANZ-I.G.T.AUSTRALIAPTYLIMITE[/I]
[I]ANZ-MCPHERSON'SCONSUMERPRODU[/I]
[I]ANZ-AUCKLANDUNIVERSITYOFTECH[/I]
[I]ANZ-INTERMODALGROUP[/I]
[I]ANZ-FUTUREFUNDMANAGEMENTAGEN[/I]
[I]ANZ-AustralianSuper[/I]
[I]ANZ-REGIONALPOWERCORPORATION[/I]
[I]ANZ-AUSTRALIANSUPERPTYLTD[/I]
[I]ANZ-STEAMSHIPSPTYLTD[/I]
[I]ANZ-VicRoads[/I]
[I]ANZ-XENCONNECTPTYLTD[/I]
[I]ANZ-VODAFONEHUTCHISONAUSTRAL[/I]
[I]ANZ-IPDGROUPLIMITED[/I]
[I]ANZ-RayWhiteRealEstate[/I]
[I]ANZ-VODAFONEHUTCHISONAUSTRAL[/I]
[I]ANZ-VODAFONEHUTCHISONAUSTRAL[/I]
[I]ANZ-KIWIPLANNZ.[/I]
[I]ANZ-CORNELLFUELINJECTION&[/I]
[I]ANZ-ALCOAOFAUSTRALIALIMITED[/I]
[I]ANZ-TAITELECTRONICSLIMITED[/I]
[I]ANZ-VEGASENTERPRISESPTYLTD[/I]
[I]ANZ-PAPERAUSTRALIAPTYLTD[/I]
[I]ANZ-PAPERAUSTRALIAPTYLTD[/I]
[I]ANZ-SANOFI-AVENTISAUSTRALIAP[/I]
[I]ANZ-AUCKLANDUNIVERSITYOFTECH[/I]
[I]ANZ-AustralianSuper[/I]
[I]ANZ-PGSAUSTRALIAPTYLIMITED[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-RUSSELLKENNEDYSOLICITORS[/I]
[I]ANZ-DIRECTPAYMENTSOLUTIONSLT[/I]
[I]ANZ-COCACOLAAMATIL(AUST)PTYL[/I]
[I]ANZ-ANZNEWZEALANDINVESTMENTS[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-Westpac[/I]
[I]ANZ-I-MEDNETWORKLIMITED[/I]
[I]ANZ-Westpac[/I]
[I]ANZ-Westpac[/I]
[I]ANZ-VICTORIAUNIVERSITY[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-ASPENMEDICALPTYLIMITED[/I]
[I]ANZ-INSURANCEAUSTRALIALIMITE[/I]
[I]ANZ-O-IASIAPACIFIC[/I]
[I]ANZ-AustralianSuper[/I]
[I]ANZ-AustralianSuper[/I]
[I]ANZ-GOODMANFIELDERNEWZEALAND[/I]
[I]ANZ-VICTORIAUNIVERSITY[/I]
[I]ANZ-ENERGYAUSTRALIAPTYLIMITE[/I]
[I]ANZ-ORICAAUSTRALIAPTYLIMITED[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-NEWSOUTHWALESELECTORALCO[/I]
[I]ANZ-NEWCRESTMININGLIMITED[/I]
[I]ANZ-ENERGYAUSTRALIAPTYLIMITE[/I]
[I]ANZ-TYCOELECTRONICSENERGYPTY[/I]
[I]ANZ-NATIONALAUSTRALIABANKLTD[/I]
[I]ANZ-BENDIGOCOMMUNITYTELCO[/I]
[I]ANZ-PAYMARKLTD[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-QANTASINFORMATION[/I]
[I]ANZ-SCHLUMBERGERAUSTRALIAPTY[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-YARRAVALLEYWATER[/I]
[I]ANZ-THEWELLINGTONFREEAMBULAN[/I]
[I]ANZ-OFFICESWORKSSUPERSTORESP[/I]
[I]ANZ-KMARTAUSTRALIALTD[/I]
[I]ANZ-TOLLHOLDINGSLIMITED[/I]
[I]ANZ-PERNODRICARDWINEMAKERSPT[/I]
[I]ANZ-BENDIGOBANKANDADELAIDEBA[/I]
[I]ANZ-VICTORIAUNIVERSITY[/I]
[I]ANZ-RioTinto[/I]
[I]ANZ-PORTMACQUARIEHASTINGSCOU[/I]
[I]ANZ-AUSTRALIANSECURITIES&[/I]
[I]ANZ-GPTMANAGEMENTHOLDINGS[/I]
[I]ANZ-UBSAG[/I]
[I]ANZ-STANDARDCHARTEREDBANK,[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-BIOCSLPTYLTD[/I]
[I]ANZ-WAALCOHOL&DRUGAUTHORITY[/I]
[I]ANZ-SUPERRETAILGROUPSERVICES[/I]
[I]ANZ-Suncorp[/I]
[I]ANZ-NSWBUSINESSLINKPTYLIMITE[/I]
[I]ANZ-DELOITTETOUCHETOHMATSU[/I]
[I]ANZ-CENTRALCOASTAREAHEALTH[/I]
[I]ANZ-HYUNDAIMOTORCOMPANY[/I]
[I]ANZ-LeasePlanAustralia[/I]
[I]ANZ-7ELEVENSTORESPTYLTD[/I]
[I]ANZ-DEPARTMENTOFJUSTICE[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-TOYOTAMOTORCORPAUSTLTD[/I]
[I]ANZ-BENDIGOBANKANDADELAIDEBA[/I]
[I]ANZ-DeptofDefence[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-HUMECITYCOUNCIL[/I]
[I]ANZ-SUPERANNUATIONADMINISTRA[/I]
[I]ANZ-HEALTHSUPPORTSERVICES[/I]
[I]ANZ-FUJIFILMAUSTRALIAPTYLTD[/I]
[I]ANZ-UNITEDENERGYDISTRIBUTION[/I]
[I]ANZ-ManufacturedHomesInsuran[/I]
[I]ANZ-AUSTRALIANINSURANCEHOLDI[/I]
[I]ANZ-SUNCORPCORPORATESERVICES[/I]
[I]ANZ-ORICAAUSTRALIAPTYLIMITED[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-ASPENPHARMAPTYLTD[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-CloudM[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-UniversityofWesternSydne[/I]
[I]ANZ-THEUNIVERSITYOFNEWCASTLE[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-SYDNEYWATERCORPORATION[/I]
[I]ANZ-CHURCHESOFCHRISTIN[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-DEPARTMENTOFEDUCATION[/I]
[I]ANZ-HUMECITYCOUNCIL[/I]
[I]ANZ-CONNECTEASTPTYLIMITED[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-LENDLEASE[/I]
[I]ANZ-NBNCOLIMITED[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-ENDEAVOURENERGY[/I]
[I]ANZ-WESTFIELDLTD[/I]
[I]ANZ-GOULBURN-MURRAY[/I]
[I]ANZ-CROWNMELBOURNELIMITED[/I]
[I]ANZ-RioTinto[/I]
[I]ANZ-DULUXGROUPLIMITED[/I]
[I]ANZ-SYDNEYOPERAHOUSETRUST[/I]
[I]ANZ-CommittoPtyLtd[/I]
[I]ANZ-GLENFERRIEPRIMARYSCHOOLC[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-NOWITSOLUTIONSPTYLTD[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-NZAUTOMOBILEASSOCIATIONI[/I]
[I]ANZ-QSUPERLIMITED[/I]
[I]ANZ-VICTORIARACINGCLUBLIMITE[/I]
[I]ANZ-METLIFEINSURANCELIMITED[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-InterfaceFLOR[/I]
[I]ANZ-KEYSTARTLOANSLIMITED[/I]
[I]ANZ-WESTPACBANKINGCORPORATIO[/I]
[I]ANZ-KEYSTARTLOANSLIMITED[/I]
[I]ANZ-LAKESDISTRICTHEALTHBOARD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-METROPOLITANAMBULANCESER[/I]
[I]ANZ-METROPOLITANAMBULANCESER[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-AUSTRALIANSECURITIES&[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-ASBBANKLTD[/I]
[I]ANZ-WESTFIELDLTD[/I]
[I]ANZ-DATACOMAUSTRALIAHOLDINGS[/I]
[I]ANZ-INTRALOTAUSTRALIAPTYLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-RGMForex[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-OFFICEOFPUBLICPROSECUTIO[/I]
[I]ANZ-HUMECITYCOUNCIL[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-HUMECITYCOUNCIL[/I]
[I]ANZ-AUSTRALIANPRUDENTIAL[/I]
[I]ANZ-CALTEXAUSTRALIAPETROLEUM[/I]
[I]ANZ-S.SMITH&SONPTYLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-NATIONALWEALTHMANAGEMENT[/I]
[I]ANZ-BRITISHAMERICANTOBACCOAU[/I]
[I]ANZ-DOMINO'SPIZZAENTERPRISES[/I]
[I]ANZ-AVNETTECHNOLOGYSOLUTIONS[/I]
[I]ANZ-NUANCECOMMUNICATIONS[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-BARBEQUESGALORE(AUST)PTY[/I]
[I]ANZ-ADIMUNITIONSPTYLIMITED[/I]
[I]ANZ-UNITECINSTITUTEOFTECHNOL[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-METCASHTRADINGLIMITED[/I]
[I]ANZ-DEBORTOLIWINESPTYLIMITED[/I]
[I]ANZ-UNITECINSTITUTEOFTECHNOL[/I]
[I]ANZ-CROWNEQUIPMENTPTYLTD[/I]
[I]ANZ-AUSBILDEXIALIMITED[/I]
[I]ANZ-AUSTRALIANFOOTBALLLEAGUE[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-DEPARTMENTOFJUSTICE[/I]
[I]ANZ-KRONOSAUSTRALIAPTYLIMITE[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-VOYAGERINTERNETLIMITED[/I]
[I]ANZ-VODAFONENZLTD[/I]
[I]ANZ-VEOLIAENVIRONMENTALSERVI[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-SCHLUMBERGERAUSTRALIAPTY[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-SYDNEYWATERCORPORATION[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-WESTFIELDLIMITED[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-GREATERBENDIGOCITYCOUNCI[/I]
[I]ANZ-QUEENSLANDPOLICECREDITUN[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-WORLDXCHANGE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-GOMARKETSPTYLTD[/I]
[I]ANZ-AUSTRALIANCENTRAL[/I]
[I]ANZ-QantasAirwaysLimited[/I]
[I]ANZ-PAZGROUP(AKABARONFORGE)[/I]
[I]ANZ-NAPOLEONCOSMETICSPTYLTD[/I]
[I]ANZ-AIRSERVICESAUSTRALIA[/I]
[I]ANZ-MUTUALITYCORPORATIONPTYL[/I]
[I]ANZ-FLETCHERCHALLENGESTEELPR[/I]
[I]ANZ-PENTANASOLUTIONSPTYLTD[/I]
[I]ANZ-CROWNMELBOURNELIMITED[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-SHRIROAUSTRALIAPTYLIMITE[/I]
[I]ANZ-ANAHITAGROUPPROPRIETARYL[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-NATURALHISTORYOFNZLTD[/I]
[I]ANZ-NATURALHISTORYOFNZLTD[/I]
[I]ANZ-TELCOSERVICESAUSTRALIA[/I]
[I]ANZ-EUROPEANMOTORS[/I]
[I]ANZ-SPENDVISIONLIMITED[/I]
[I]ANZ-HEALTHSUPPORTSERVICES[/I]
[I]ANZ-HEALTHSUPPORTSERVICES[/I]
[I]ANZ-SCHLUMBERGERAUSTRALIAPTY[/I]
[I]ANZ-OFFICEOFPUBLICPROSECUTIO[/I]
[I]ANZ-MINISTRYOFSOCIALDEVELOPM[/I]
[I]ANZ-ASBBANKLIMITED[/I]
[I]ANZ-ASBBANKLIMITED[/I]
[I]ANZ-ASBBANKLIMITED[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-VICTORIAUNIVERSITY[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-TELSTRACORPORATION[/I]
[I]ANZ-CONCENTRIXSERVICESPTYLTD[/I]
[I]ANZ-DAVIDJONESLIMITED[/I]
[I]ANZ-DOWCHEMICAL(AUSTRALIA)LT[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-ASBBANKLIMITED[/I]
[I]ANZ-BLUMARKPTYLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-NZPOLICE[/I]
[I]ANZ-ASBBANKLIMITED[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-ALCOAOFAUSTRALIALIMITED[/I]
[I]ANZ-SCHLUMBERGERAUSTRALIAPTY[/I]
[I]ANZ-SCHLUMBERGERAUSTRALIAPTY[/I]
[I]ANZ-NUANCECOMMUNICATIONS[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-KMARTAUSTRALIALTD[/I]
[I]ANZ-ASBBANKLTD[/I]
[I]ANZ-PanamexAustraliaPtyLtd[/I]
[I]ANZ-GCOMMPTYLTD[/I]
[I]ANZ-KMARTAUSTRALIALTD[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-ASBBankLimited(HeadOffic[/I]
[I]ANZ-ASBBANKSOFTWARESERVICESL[/I]
[I]ANZ-EBIXAUSTRALIAPTYLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-SCHLUMBERGERAUSTRALIAPTY[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-OFFICEMAXAUSTRALIALIMITE[/I]
[I]ANZ-OFFICEMAXAUSTRALIALIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-STATESTREETAUSTRALIALIMI[/I]
[I]ANZ-HBFHEALTHFUNDSINCORPORAT[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-AucklandUniversityofTech[/I]
[I]ANZ-ALZHEIMER'SAUSTRALIANSW[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-THEDEMPSEYGROUPPTYLTD[/I]
[I]ANZ-BEIRUTHELLENICBANKLTD[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-AGCOAUSTRALIALIMITED[/I]
[I]ANZ-O2NETWORKSPTYLTD[/I]
[I]ANZ-FLUORAUSTRALIAPTYLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-ASBBankLimited(HeadOffic[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-WORLDXCHANGE[/I]
[I]ANZ-OFFICEOFTHECLERK[/I]
[I]ANZ-ASBBANKLIMITED[/I]
[I]ANZ-OFFICEOFTHECLERK[/I]
[I]ANZ-TELSTRACORPORATION[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-7ELEVENSTORESPTYLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-KNAUFPLASTERBOARDPTYLIMI[/I]
[I]ANZ-DFSAUSTRALIAPTYLIMITED[/I]
[I]ANZ-NATIONALAUSTRALIABANKLIM[/I]
[I]ANZ-BENDIGOANDADELAIDEBANKLI[/I]
[I]ANZ-KOZIHOSPITALITYGROUPPTYL[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-CONCENTRIXSERVICESPTYLTD[/I]
[I]ANZ-AucklandUniversityofTech[/I]
[I]ANZ-LAKESDISTRICTHEALTHBOARD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-NEWSCORPORATIONNOMINEESP[/I]
[I]ANZ-BUNNINGSGROUPLIMITED[/I]
[I]ANZ-IINETLIMITED[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-TECHNOLOGICALRESOURCESPT[/I]
[I]ANZ-CATCHOFTHEDAY.COM.AUPTYL[/I]
[I]ANZ-SCHLUMBERGERAUSTRALIAPTY[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-SPENDVISIONLIMITED[/I]
[I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I]
[I]ANZ-DEPARTMENTOFTRANSPORT[/I]
[I]ANZ-DanArcherMedical[/I]
[I]ANZ-VODAFONEFIXEDLIMITED[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-BENDIGOCOMMUNITYTELCO[/I]
[I]ANZ-VICTORIAUNIVERSITY[/I]
[I]ANZ-AustraliaandNewZealandBa[/I]
[I]ANZ-GARRY&WARRENSMITHPTYLTD[/I]
[I]ANZ-REMONDISPTYLTD[/I]
[I]ANZ-INTERMOTORSALESPTYLTD[/I]
[I]ANZ-LAWRENCESMOTORSPTYLTD[/I]
[I]ANZ-BASS&EQUITABLEBLDGSOCIET[/I]
[I]ANZ-BEGACHEESELIMITED[/I]
[I]ANZ-ACTMAGISTRATESCOURT[/I]
[I]ANZ-TheBMDGroup[/I]
[I]ANZ-NEWEDGEAUSTRALIAPTYLTD[/I]
[I]ANZ-NEWEDGEAUSTRALIAPTYLTD[/I]
[I]ANZ-NATIONALAUSTRALIABANKLIM[/I]
[I]ANZ-AucklandUniversityofTech[/I]
[I]ANZ-HEALTHALLIANCEN.ZLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-M2TELECOMMUNICATIONSPTYL[/I]
[I]ANZ-VODAFONEHUTCHISONAUSTRAL[/I]
[I]ANZ-Mercedes-BenzNewZealandL[/I]
[I]ANZ-RACINGANDWAGERINGWESTERN[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-AUSTRALIANSECURITIES&[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-VENTYXPTYLTD[/I]
[I]ANZ-TELSTRACORPORATIONLIMITE[/I]
[I]ANZ-RAILWAYSCREDITUNIONLIMIT[/I]
[I]ANZ-CSL[/I]
ReferenceSheet - The data against which Sheet1 column BZ is matched (should be on the sheet with the name "ReferenceSheet" between B3:B18.
Code:
[TABLE="width: 459"]
<tbody>[TR]
[TD][I]ANZ-ANZBank[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-AUSTRALIANCUSTOMS[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-BHPBilliton[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-Coca-Cola[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-COMMONWEALTHBANKOFAUSTRA[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-DEPARTMENTOFDEFENCE[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-DHS[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-NationalAustraliaBank[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-NationalBroadbandNetwork[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-QANTASAIRWAYSLIMITED[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-Suncorp[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-Telstra[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-TRUENERGYYALLOURNPTYLTD[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-VodafoneAustralia[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-Westfield[/I][/TD]
[/TR]
[TR]
[TD][I]ANZ-WestpacBankingCorporatio[/I][/TD]
[/TR]
</tbody>[/TABLE]
Sheet2 - Should be present always as this is the sheet into which the matched rows are copied
Objective. Copy all rows which have a identifier matching with the ones present in "ReferenceSheet" and paste into a new sheet ("Sheet2")
Sheet1 has a table with many rows and a column BZ which has identifier to look for a match from the "ReferenceSheet"
If there is a match, the macro copies the row and puts into Sheet2
This is the macro code
Code:
Sub SearchForComparisonStringAndCopy()
Dim SearchRowCounter As Long
Dim CopyToRow As Long
'Copying Comparison String Names to an array
Dim MyArray As Variant
Dim MyArray_Count As Long
Dim MyArray_Counter As Long
Sheets("ReferenceSheet").Select
MyArray = Range("B3:B18").Value
MyArray_Count = Range("B3:B18").Count
'Start copying data to row 2 in Sheet2 (row counter variable)
CopyToRow = 2
'Copy Table fields from Sheet1 to Sheet2
Sheets("Sheet1").Select
Range("A1:BZ1").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
'Start search in row 3
SearchRowCounter = 1
Sheets("Sheet1").Select
Do While SearchRowCounter < 100000
MyArray_Counter = 1
Do While MyArray_Counter < MyArray_Count + 1
'If value in column BZ is same as the value in column B from Reference_Sheet copy entire row to Sheet2
If Range("BZ" & CStr(SearchRowCounter)).Value = MyArray(MyArray_Counter, 1) Then
'Select row in Sheet1 to copy
Rows(CStr(SearchRowCounter) & ":" & CStr(SearchRowCounter)).Select
Selection.Copy
'Paste row into Sheet2
Sheets("Sheet2").Select
Rows(CStr(CopyToRow) & ":" & CStr(CopyToRow)).Select
ActiveSheet.Paste
'Move counter to next row
CopyToRow = CopyToRow + 1
'Go back to Sheet1 to continue searching
Sheets("Sheet1").Select
End If
MyArray_Counter = MyArray_Counter + 1
Loop
SearchRowCounter = SearchRowCounter + 1
Loop
Sheets("Sheet2").Select
Cells.Select
Cells.EntireColumn.AutoFit
Range("A1").Select
MsgBox "All matching data has been copied."
Exit Sub
End Sub
Problem
The code is working ok as it copies some rows with matched identifiers but it's missing out few even though the comparison strings are exactly the same. The three strings from "Sheet1" match with the ones in "ReferenceSheet" but are not copied to "Sheet2" when I run the macro.
ANZ-NATIONALAUSTRALIABANK
ANZ-QantasAirwaysLimited
ANZ-WESTPACBANKINGCORPORATIO
I don't know where I'm going wrong and have been breaking my head for days . So I decided to seek expertise help. I'm unable to share the xlsm file else would have gladly shared.
I would really appreciate if anyone could help me with this.
Apology in case I violated any rule.
Thanks,
realdemigod