Dear Amir,
You can use folloing formulat to pul the data to main sheet from source sheet. VLOOKUP(C12,Source!$C$2:$J$14,8,FALSE) I used Account No. for look up you can modify it by chaning C12 as u required. Hope this will help you. Regards, Shafique 0333-5154498 From: aamir...@gmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: how to make unique key Date: Fri, 24 Jul 2009 21:14:59 +0500 I feel that friends are not understanding what actually issue is so please find attached my actual data sheet which consist Main & Source sheets. I just want to pick data from source sheet's highlited column and put into Main sheet's highlited column. How I handle hundred of customers. Regards, Aamir Shahzad ----- Original Message ----- From: Bakul Patel To: excel-macros@googlegroups.com Sent: Friday, July 24, 2009 7:57 AM Subject: $$Excel-Macros$$ Re: how to make unique key Hi Aamir, Just a quick question. Do you maintain this spreadsheet for one year only & create new for next year? becasue in your second sheet i can't find date. Would you please explain me what exactly you want? what is SUFF & CURR? Also Do you want closing balance on 30/06/XX only or monthly or yearly? Cheers, Bakul --- On Thu, 7/23/09, Aamir Shahzad <aamir...@gmail.com> wrote: From: Aamir Shahzad <aamir...@gmail.com> Subject: $$Excel-Macros$$ Re: how to make unique key To: excel-macros@googlegroups.com Date: Thursday, July 23, 2009, 8:49 AM Dear Vivek Agrawa, Thanks for reply. Please find attachment. In attachment two sheet available "Main sheet" where I want to fill information in column "Closing Balance" & second "Source Sheet" from where I want to pick the "Closing Balance". Remeber both sheet's data is same. Often time I have data in scattered form. e.g. Name & product missmatch. Unique is just "Branch & Account". But I am troubling to make a unique key for "sumif" or "vlookup" function. This is just example I handle data which consist thousands of rows & columns. Thanks & regards, Aamir Shahzad ----- Original Message ----- From: vivek agrawal To: excel-macros@googlegroups.com Sent: Wednesday, July 22, 2009 9:47 AM Subject: $$Excel-Macros$$ Re: how to make unique key Can u please mail a sample excel sheet to make your doubt somewhat more clear. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Jul 21, 2009 at 11:54 PM, Aamir Shahzad <aamir...@gmail.com> wrote: Dear all, Can anyone tell me please "How to make unique key" for pick required data from one sheet to another. If there is no similarity. e.g. for use of vlookup or sumif funtions. Reply will highly appriciated. Regards, Aamir Shahzad <BR _________________________________________________________________ With Windows Live, you can organize, edit, and share your photos. http://www.microsoft.com/middleeast/windows/windowslive/products/photo-gallery-edit.aspx --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
