Dear Bakul & all friends,
I know this issue that's way I asked if any possibility. And if name match in
both sheet my problem will not solve try this just because products are
different. Sumif function will only work with unique key and vlookup will pick
wrong values. Waiting for solution.
Regards,
Aamir Shahzad
----- Original Message -----
From: Bakul Patel
To: excel-macros@googlegroups.com
Sent: Saturday, July 25, 2009 2:56 PM
Subject: $$Excel-Macros$$ Re: how to make unique key
Hi Aamir,
The problem with your spreadsheet is Borrower name in Main sheet is not
matching with Account name in Source name.
e.g. In Main sheet Borrower name is "NEW ALLIED ELECTRONI" but in
Source sheet it is "NEW ALLIED ELECTRO". Means the text is not matching. If you
can make it same you can get your solution.
Cheers,
Bakul
--- On Fri, 7/24/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: Friday, July 24, 2009, 9:14 AM
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
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
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
-~----------~----~----~----~------~----~------~--~---
