Plz put all ur queries n replies to the group id. So that everyone will try n learn, that is wht our objective.
Thnx Waheed. On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales <alliage.mora...@gmail.com> wrote: > Thank you very much! > > Hope we could get in touch soon for future problems on Excel. Thank you! > > On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed <waheedb...@gmail.com> wrote: >> >> Hi John, >> >> PFA, i have deleted some rows bcoz the file size was getting huge. >> >> What u need to do is take this as example and do it in ur original >> file, in sheet 2 u need to drag down the formulas till the end. >> >> Hope it hels u >> >> Regards, >> Waheed >> >> On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales >> <alliage.mora...@gmail.com> wrote: >> > I attach my raw file. >> > >> > GEOCODE contains the geographic code >> > Other sheets contain the geographical areas without the codes >> > >> > On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed <waheedb...@gmail.com> >> > wrote: >> >> >> >> Can u plz mail a sample file. >> >> >> >> On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales >> >> <alliage.mora...@gmail.com> wrote: >> >> > If two geographical data match in two sheets, then add/copy/replicate >> >> > unique >> >> > id/code >> >> > >> >> > Hi guys, this is my problem. >> >> > >> >> > I have a geographical data (divided into four colums per REGION, >> >> > PROVINCE, >> >> > MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet >> >> > contains a >> >> > UNIQUE GEOGRAPHICAL CODE that IS NUMERICAL IN NATURE. >> >> > >> >> > Now, I have also another sheet which lists the same geographical data >> >> > (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, >> >> > and >> >> > BARANGAY/STREET). The geographic areas included in this sheet are >> >> > recipients >> >> > of one government program. But this sheet does not contain the UNIQUE >> >> > GEOGRAPHICAL CODE. >> >> > >> >> > What I would like to do is to match the geographical data found in >> >> > two >> >> > sheets, and if they match, copy/replicate/add the UNIQUE GEOGRAPHICAL >> >> > CODE >> >> > found in sheet to the other sheet that does not contain the code. >> >> > >> >> > I would like to include the geographical code, so that it would >> >> > become >> >> > the >> >> > primary key when I create a database in MS Access. >> >> > >> >> > This is the example >> >> > >> >> > SHEET 1 >> >> > A B C D E >> >> > 0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET >> >> > >> >> > *Column A contains the UNIQUE GEOGRAPHICAL CODE >> >> > >> >> > SHEET 2 >> >> > A B C D >> >> > REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET >> >> > >> >> > *Sheet 2 contains only 20k entries of geographical areas while Sheet >> >> > 1 >> >> > contains about 40k entries. Only half of the geographical areas are >> >> > included >> >> > in the government program >> >> > >> >> > Can you help me? >> >> > >> >> > >> >> > On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed <waheedb...@gmail.com> >> >> > wrote: >> >> >> >> >> >> Hi, >> >> >> >> >> >> Right Click on the pivot table, select Pivot Tabel Options, move to >> >> >> 'Data' tab and then Uncheck- "Enable Show Details". >> >> >> For the date format i think its working fine in both rows n columns. >> >> >> >> >> >> Regards, >> >> >> Waheed. >> >> >> >> >> >> On Thu, Sep 1, 2011 at 7:55 AM, Prabhu <prabhugate...@gmail.com> >> >> >> wrote: >> >> >> > HI All, >> >> >> > Plz find the pivot table sheet. >> >> >> > kindly help. >> >> >> > Regards, >> >> >> > Prabhu >> >> >> > >> >> >> > -- >> >> >> > >> >> >> > >> >> >> > >> >> >> > ---------------------------------------------------------------------------------- >> >> >> > Some important links for excel users: >> >> >> > 1. Follow us on TWITTER for tips tricks and links : >> >> >> > http://twitter.com/exceldailytip >> >> >> > 2. Join our LinkedIN group @ >> >> >> > http://www.linkedin.com/groups?gid=1871310 >> >> >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >> >> >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> >> >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> > >> >> >> > To post to this group, send email to excel-macros@googlegroups.com >> >> >> > >> >> >> > <><><><><><><><><><><><><><><><><><><><><><> >> >> >> > Like our page on facebook , Just follow below link >> >> >> > http://www.facebook.com/discussexcel >> >> >> > >> >> >> >> >> >> -- >> >> >> >> >> >> >> >> >> >> >> >> ---------------------------------------------------------------------------------- >> >> >> Some important links for excel users: >> >> >> 1. Follow us on TWITTER for tips tricks and links : >> >> >> http://twitter.com/exceldailytip >> >> >> 2. Join our LinkedIN group @ >> >> >> http://www.linkedin.com/groups?gid=1871310 >> >> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> >> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> >> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> >> >> >> >> <><><><><><><><><><><><><><><><><><><><><><> >> >> >> Like our page on facebook , Just follow below link >> >> >> http://www.facebook.com/discussexcel >> >> > >> >> > >> >> > >> >> > -- >> >> > John Alliage Tinio Morales >> >> > Researcher >> >> > GMA News and Public Affairs >> >> > Mobile: 0915.846.8473 >> >> > Tel: (02) 982.7777 loc 1338 >> >> > Fax: (02) 982.7777 loc 1340 >> >> > >> >> > >> >> > >> >> > DISCLAIMER: >> >> > This Message may contain confidential information intended only for >> >> > the >> >> > use >> >> > of the addressee named above. If you are not the intended recipient >> >> > of >> >> > this >> >> > message you are hereby notified that any use, dissemination, >> >> > distribution or >> >> > reproduction of this message is prohibited. If you received this >> >> > message >> >> > in >> >> > error please notify your Mail Administrator and delete this message >> >> > immediately. Any views expressed in this message are those of the >> >> > individual >> >> > sender and may not necessarily reflect the views of GMA Network, Inc. >> >> > >> >> > >> > >> > >> > >> > -- >> > John Alliage Tinio Morales >> > Researcher >> > GMA News and Public Affairs >> > Mobile: 0915.846.8473 >> > Tel: (02) 982.7777 loc 1338 >> > Fax: (02) 982.7777 loc 1340 >> > >> > >> > >> > DISCLAIMER: >> > This Message may contain confidential information intended only for the >> > use >> > of the addressee named above. If you are not the intended recipient of >> > this >> > message you are hereby notified that any use, dissemination, >> > distribution or >> > reproduction of this message is prohibited. If you received this message >> > in >> > error please notify your Mail Administrator and delete this message >> > immediately. Any views expressed in this message are those of the >> > individual >> > sender and may not necessarily reflect the views of GMA Network, Inc. >> > >> > > > > > -- > John Alliage Tinio Morales > Researcher > GMA News and Public Affairs > Mobile: 0915.846.8473 > Tel: (02) 982.7777 loc 1338 > Fax: (02) 982.7777 loc 1340 > > > > DISCLAIMER: > This Message may contain confidential information intended only for the use > of the addressee named above. If you are not the intended recipient of this > message you are hereby notified that any use, dissemination, distribution or > reproduction of this message is prohibited. If you received this message in > error please notify your Mail Administrator and delete this message > immediately. Any views expressed in this message are those of the individual > sender and may not necessarily reflect the views of GMA Network, Inc. > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel