Re: $$Excel-Macros$$ Pivot Table (URGENT)
Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :) On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa wrote: > Dear Mahreen > > Kindly find the attached file and see the yellow highlighted row ,i have > did the same w/o pivot > > > > On Thu, Jan 19, 2012 at 11:12 PM, Mahreen Ellahi > wrote: > >> Guys >> >> I have a range of data of which I want to plot a pivot table. My problem >> is that I have different expiry days but I want to club or group into >> certain buckets like <0 days,1- 30 days, 31-60 days etc. I dont want to >> take unexpired negative values in my pivot table. HELP NEEDED IN ATTACHED >> FILE. SAMPLE FORMAT ATTACHED BUT NOT AS A PIVOT TABLE. >> >> S # REGION BRANCH SEGMENT CUSTOMER NAME DATE OF APPROVAL ORIGINAL >> APPROVING AUTHORITY TOTAL FUNDED & NON-FUNDED LIMIT (IN MILLION) DATE OF >> INTERIM REVIEW ANNUAL REVIEW DATE VALIDITY / EXPIRY Days Expired 1 SOUTH >> I KHI CORPORATEABC 07-Oct-2010 CC 50.000 31-Mar-2012 >> 31-Mar-2012 (90) 2 SOUTH I KHI COMMERCIAL DEF >> 23-Dec-2010 CC 300.000 31-Dec-2011 31-Dec-2011 1 3 SOUTH >> I KHI COMMERCIAL SDS 02-Feb-2011 CC 682.940 29-Feb-2012 28-Feb-11 >> 307 4 SOUTH I KHI CORPORATE FDFG 01-Nov-2010 CC 300.000 >> 31-Mar-2012 31-Mar-2012 (90) 5 SOUTH I KHI CORPORATE >> DFG 02-May-2011 CC 1,200.000 31-Mar-2012 31-Mar-2011 276 >> 6 SOUTH I KHI SME FDFG 25-Aug-2010 CC 375.000 31-Mar-2012 31-Mar-2012 >> (90) 7 SOUTH I KHI SME SDF 03-May-2011 CC 600.000 31-Mar-2012 >> 31-Mar-2010 641 8 SOUTH I KHI SME SDF 27-Jun-2011 CC 620.000 >> 30-Apr-2012 30-Apr-2012(120) 9 SOUTH I KHI CORPORATE DSF >> 22-Mar-2011 CC 210.000 30-Apr-2012 30-Sep-2011 93 10 SOUTH >> I KHI CORPORATE SDF 23-May-2011 CC 471.000 30-Apr-2012 30-Apr-2012 >> (120) 11 SOUTH I KHI COMMERCIAL SDF 10-May-2011 CC 800.000 30-Apr-2012 >> 30-Apr-2012(120) 12 SOUTH I KHI CORPORATE SDF 23-May-2011 CC >> 1,300.000 >> 31-Mar-2012 31-Mar-2012 (90) 13 SOUTH I KHI CORPORATE >> FDFG 13-Jul-2011 CC 1,300.000 31-Aug-2012 31-Aug-2011 123 >> 14 SOUTH I KHI SME DFG 24-Jun-2010 CC 1,200.000 30-Sep-2011 30-Sep-2011 >> 93 15 SOUTH I KHI CORPORATE DFG 18-Mar-2011 CC 400.000 31-Dec-2011 >> 31-Dec-2011 1 16 SOUTH I KHI SME FDFGSD 02-Nov-2011 CC >> 300.000 >> 31-Dec-2012 31-Jan-2009 1,065 17 SOUTH I KHI CORPORATE SDF >> 28-Mar-2011 CC 400.000 31-Mar-2012 31-Mar-2012 (90) 18 SOUTH >> I KHI COMMERCIAL SDF 23-Nov-2011 CC 900.000 31-Dec-2012 31-Dec-2012 >> (365) 19 SOUTH I KHI CORPORATE SDF 17-Jun-2011 CC 2,000.000 >> 30-Apr-2012 30-May-2011 216 20 SOUTH I KHI COMMERCIAL SDF >> 28-Mar-2011 CC 1,700.000 30-Apr-2012 30-Apr-2012(120) >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss
Re: Re: Re: Re: $$Excel-Macros$$ Font size in drop-down menu
Nop didnt get the desired result, anyways m making a new sheet with 100% zoom and its working thanks Mahreen On Thu, Nov 10, 2011 at 7:49 PM, wrote: > For example, with Data Validation cells in column D: > Private Sub Worksheet_SelectionChange(ByVal Target As Range) > If Target.Count > 1 Then Exit Sub > If Target.Column = 4 Then > Target.Columns.ColumnWidth = 20 > Else > Columns(4).ColumnWidth = 5 > End If > End Sub > > To add this code to the worksheet: > Right-click on the sheet tab, and choose View Code. > Copy the code, and paste it onto the code module. > Change the column reference from 4 to match your worksheet > > On , Mahreen Ellahi wrote: > > Any code? > > > > On Thu, Nov 10, 2011 at 3:55 PM, waheedb...@gmail.com> wrote: > > > > > > Well u can use the code mentioned in the link to make it zoom a bit > > > > > > > > > > > > On , Mahreen Ellahi mahreen.acc...@gmail.com> wrote: > > > > > > > Thanks :-( > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Thu, Nov 10, 2011 at 3:43 PM, waheedb...@gmail.com> wrote: > > > > > > > > > > > > > > > > > > > > > Hi, > > > > > > > Its fixed size you cant change it. > > > > > > > Plz refer the below link > > > > > > > http://www.contextures.com/xldataval08.html > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On , Mahreen Ellahi mahreen.acc...@gmail.com> wrote: > > > > > > > > I ve already gone through this link, thanks. But i dont ve a combo > box, i ve used data validation. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On Thu, Nov 10, 2011 at 3:27 PM, waheedb...@gmail.com> wrote: > > > > > > > > > > > > > > > > > > > > > > > > Hi, > > > > > > > > Please refer the link > > > > > > > > > > > > > > > > > > > > > > http://www.contextures.com/xlDataVal10.html > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Regards, > > > > > > > > waheed > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On , Mahreen Ellahi mahreen.acc...@gmail.com> wrote: > > > > > > > > > Can anybody tell me how to increase font size in drop down menu > like when a user selects the menu, the options are too small and not > visible. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > regards > > > > > > > > > > > > > > > > > > > > > > > > > > > Mahreen > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > > > > > > > > > > > > > &g
Re: Re: Re: $$Excel-Macros$$ Font size in drop-down menu
Any code? On Thu, Nov 10, 2011 at 3:55 PM, wrote: > Well u can use the code mentioned in the link to make it zoom a bit > > On , Mahreen Ellahi wrote: > > Thanks :-( > > > > > > > > On Thu, Nov 10, 2011 at 3:43 PM, waheedb...@gmail.com> wrote: > > > > > > Hi, > > Its fixed size you cant change it. > > Plz refer the below link > > http://www.contextures.com/xldataval08.html > > > > > > > > > > > > > > > > On , Mahreen Ellahi mahreen.acc...@gmail.com> wrote: > > > I ve already gone through this link, thanks. But i dont ve a combo > box, i ve used data validation. > > > > > > > > > > > > > > > > On Thu, Nov 10, 2011 at 3:27 PM, waheedb...@gmail.com> wrote: > > > > > > > > > Hi, > > > Please refer the link > > > > > > > http://www.contextures.com/xlDataVal10.html > > > > > > > > > > > > Regards, > > > waheed > > > > > > > > > > > > > > > > > > > On , Mahreen Ellahi mahreen.acc...@gmail.com> wrote: > > > > Can anybody tell me how to increase font size in drop down menu like > when a user selects the menu, the options are too small and not visible. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > regards > > > > > > > > > > > > Mahreen > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > > > > > > FORUM RULES (934+ members already BANNED for violation) > > > > > > > > > > > > > > > > > > > > > > > > > > > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 2) Don't post a question in the thread of another member. > > > > > > > > > > > > > > > > > > > > > > > > > > > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 4) Acknowledge the responses you receive, good or bad. > > > > > > > > > > > > > > > > > > > > > > > > > > > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > FORUM RULES (934+ members already BANNED for violation) > > > > > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > > > > > > > > > > > > > > > 2) Don't post a question in the thread of another member. > > > > > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > > > > > 4) Acknowledge the responses you receive, good or bad. > > > > > > > > > > > > > > > > 5) Cr
Re: Re: $$Excel-Macros$$ Font size in drop-down menu
Thanks :-( On Thu, Nov 10, 2011 at 3:43 PM, wrote: > Hi, > Its fixed size you cant change it. > Plz refer the below link > http://www.contextures.com/xldataval08.html > > On , Mahreen Ellahi wrote: > > I ve already gone through this link, thanks. But i dont ve a combo box, > i ve used data validation. > > > > > > > > On Thu, Nov 10, 2011 at 3:27 PM, waheedb...@gmail.com> wrote: > > > > > > Hi, > > Please refer the link > > http://www.contextures.com/xlDataVal10.html > > > > > > > > Regards, > > waheed > > > > > > > > > > On , Mahreen Ellahi mahreen.acc...@gmail.com> wrote: > > > Can anybody tell me how to increase font size in drop down menu like > when a user selects the menu, the options are too small and not visible. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > regards > > > > > > > > > Mahreen > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > FORUM RULES (934+ members already BANNED for violation) > > > > > > > > > > > > > > > > > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need > Advice will not get quick attention or may not be answered. > > > > > > > > > > > > > > > > > > > > > > 2) Don't post a question in the thread of another member. > > > > > > > > > > > > > > > > > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > > > > > > > > > > > > > > > > > > > > > 4) Acknowledge the responses you receive, good or bad. > > > > > > > > > > > > > > > > > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > > > > > > > > > > > > > > > > > > > > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > > > > > > > > > > > > > > > -- > > FORUM RULES (934+ members already BANNED for violation) > > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > > > > > > > 2) Don't post a question in the thread of another member. > > > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > > > 4) Acknowledge the responses you receive, good or bad. > > > > > > > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > > > > > > -- > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > FORUM RULES (934+ members already BANNED for violation) > > > > > > > > > > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > > > > > > > > > > > 2) Don't post a question in the thread of another member. > > > > > > > > > > > > 3) Don't p
Re: $$Excel-Macros$$ Font size in drop-down menu
I ve already gone through this link, thanks. But i dont ve a combo box, i ve used data validation. On Thu, Nov 10, 2011 at 3:27 PM, wrote: > Hi, > Please refer the link > http://www.contextures.com/xlDataVal10.html > > Regards, > waheed > On , Mahreen Ellahi wrote: > > Can anybody tell me how to increase font size in drop down menu like > when a user selects the menu, the options are too small and not visible. > > > > > > > > > > > > > > > > > > regards > > > > > > Mahreen > > > > > > > > > > > > > > > > > > > > -- > > > > > > FORUM RULES (934+ members already BANNED for violation) > > > > > > > > > > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > > > > > > > > > > > 2) Don't post a question in the thread of another member. > > > > > > > > > > > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > > > > > > > > > > > 4) Acknowledge the responses you receive, good or bad. > > > > > > > > > > > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > > > > > > > > > > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > > > > > > > > > > > > -- > > > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > > > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Font size in drop-down menu
Can anybody tell me how to increase font size in drop down menu like when a user selects the menu, the options are too small and not visible. regards Mahreen -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Help
Sorry i checked late Wowww such a simple solution great thanks alot Mahreen On Thu, Nov 3, 2011 at 10:23 PM, Sam Mathai Chacko wrote: > So did you check my post? > > Sam > > > On Thu, Nov 3, 2011 at 10:03 PM, Mahreen Ellahi > wrote: > >> I want the user either to have score or NA. When all boxes are marked by >> NA or score, all scores should be added for final score. >> >> >> On Thu, Nov 3, 2011 at 9:30 PM, dguillett1 wrote: >> >>> What do you want when one or the other is NA and how is the cell >>> populated with NA >>> >>> Don Guillett >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Mahreen Ellahi >>> *Sent:* Thursday, November 03, 2011 10:33 AM >>> *To:* excel-macros@googlegroups.com >>> *Subject:* Re: $$Excel-Macros$$ Help >>> >>> I ve to add points scored in each table. When the points are NA, total >>> is not possible. Plz see attached file. >>> >>> Mahreen >>> >>> On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan < >>> haseeb.avarak...@gmail.com> wrote: >>> >>>> Mahreen, >>>> >>>> If you have multiple ratio values define a name for them each, like >>>> Table1, Table2 & choose which table to use. >>>> >>>> See the attached. >>>> >>>> >>>> >>>> HTH >>>> Haseeb >>>> -- >>>> FORUM RULES (925+ members already BANNED for violation) >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> >>>> 2) Don't post a question in the thread of another member. >>>> >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> >>>> 4) Acknowledge the responses you receive, good or bad. >>>> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> -- >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>> >>> -- >>> FORUM RULES (925+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> -- >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> -- >>> FORUM RULES (925+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any
Re: $$Excel-Macros$$ Help
I want the user either to have score or NA. When all boxes are marked by NA or score, all scores should be added for final score. On Thu, Nov 3, 2011 at 9:30 PM, dguillett1 wrote: > What do you want when one or the other is NA and how is the cell > populated with NA > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Mahreen Ellahi > *Sent:* Thursday, November 03, 2011 10:33 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help > > I ve to add points scored in each table. When the points are NA, total is > not possible. Plz see attached file. > > Mahreen > > On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan < > haseeb.avarak...@gmail.com> wrote: > >> Mahreen, >> >> If you have multiple ratio values define a name for them each, like >> Table1, Table2 & choose which table to use. >> >> See the attached. >> >> >> >> HTH >> Haseeb >> -- >> FORUM RULES (925+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> > > -- > FORUM RULES (925+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > -- > FORUM RULES (925+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Help
I ve to add points scored in each table. When the points are NA, total is not possible. Plz see attached file. Mahreen On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan wrote: > Mahreen, > > If you have multiple ratio values define a name for them each, like > Table1, Table2 & choose which table to use. > > See the attached. > > > > HTH > Haseeb > > -- > FORUM RULES (925+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Formula In Validation List.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Help
Thanks both of u for the solution :-) I have different cells in my sheet
which are to be added which includes both text and number. I am not able
generate result with these formulas. Once again help needed.
On Wed, Nov 2, 2011 at 12:11 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello Sam;
>
> A nice solution with Validation.
>
> Hello Mahreen;
>
> If you use "3", "2", "1" (number inside "") this will return the number as
> text. When you do calculation excel is considering these as text. Use it
> without "" or you can simplify the formula to;
>
> =IFERROR(LOOKUP($E$2,{-9E+300,3;3,1;4,0;5,-3}),0)
>
> and use it as Sam shows.
>
> Another way is to ignore all error values when summing;
>
> =SUMIF(A:A,"<9E300")
>
> ___
> HTH
> Haseeb
>
> --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
Formula In Validation List.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Help
Hey thanks, but one more prob, wen i sum up all such scores with few numbers and text NA, i cant derive the total score. Ofcourse its a text thatsy but is there any possibility i can show the result ignoring the NA On Tue, Nov 1, 2011 at 10:23 PM, Sam Mathai Chacko wrote: > Here's how you do it Mahreen. > > Create a named range using the formula you already have. And in > validation, use List, and type NA,=NmRnge > > where NmRnge is your named range > > Check attached. > > Sam > > > On Tue, Nov 1, 2011 at 9:53 PM, Mahreen Ellahi > wrote: > >> Guys >> >> I have some serious and need some help. >> >> I have an excel file with these field >> >> Debt : Equity Ratio >> *Insert Debt to Equity Ratio: * *3.00* Up to 2 3 Above 2 to 3 1 Above >> 3 to 4 0 Above 4 -3 Score 1 >> The score is derived through a formula. The cell shall be protected and >> no formula will be visible. >> >> My problem is where the cell will be marked as NA. I created a drop down >> menu for this purpose in same cell which is linked with formula. Now the >> cell has option for NA. Once it is marked, there is no option available for >> reverting back to formula where the score can be read. Is there anyway to >> read the score. >> >> Help needed. >> >> Regards >> Mahreen >> >> >> -- >> FORUM RULES (925+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> -- >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > -- > Sam Mathai Chacko > > -- > FORUM RULES (925+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Help
Guys I have some serious and need some help. I have an excel file with these field Debt : Equity Ratio *Insert Debt to Equity Ratio: * *3.00* Up to 2 3 Above 2 to 3 1 Above 3 to 4 0 Above 4 -3 Score 1 The score is derived through a formula. The cell shall be protected and no formula will be visible. My problem is where the cell will be marked as NA. I created a drop down menu for this purpose in same cell which is linked with formula. Now the cell has option for NA. Once it is marked, there is no option available for reverting back to formula where the score can be read. Is there anyway to read the score. Help needed. Regards Mahreen -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Excel Pop-ups
Thanks all, it worked. Regards On Sun, Jul 3, 2011 at 11:54 PM, STDEV(i) wrote: > please try: > = > Sub ExpiryWarning() > Dim dTable As Range, t As String >Dim R As Long, N As Long, *I As Date* > >Set dTable = Cells(1).CurrentRegion >N = dTable.Rows.Count > >For R = 2 To N > If IsDate(dTable(R, 14)) Then > I = dTable(R, 14) - Date > If I <= 15 Then > If I > 0 Then > dTable(R, 1).Resize(1, dTable.Columns.Count).Select > t = "Name : " & dTable(R, 4) & vbCr & vbCr > t = t & "Expiry Date : " & Format(dTable(R, 14), "dd-mmm-") > & vbCr & vbCr > t = t & "Number of days to expire : " & Format(I, "0") & vbCr > MsgBox t, 48, "Warning" > End If > End If > End If >Next > Cells(1).Activate > End Sub > = > > > On Sun, Jul 3, 2011 at 7:16 PM, Mahreen Ellahi > wrote: > >> Hiii >> >> Thanks to ST Devi, I have reached up to this level , but the code shows >> some error now. Can anybody plz help me out. >> >> Regards >> >> -- Forwarded message -- >> From: Mahreen Ellahi >> Date: Sat, Jun 18, 2011 at 10:25 PM >> Subject: $$Excel-Macros$$ Excel Pop-ups >> To: excel-macros@googlegroups.com >> >> >> Hii >> >> I have a some data with limits expiry on different dates. I want to have >> popup window to appear whenever the limit is about to expire like 15 to 30 >> days earlier. Can anyone help me for VBA coding. >> >> Regards >> Mahreen >> >> -- >> >> -- >> 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 >> > > -- -- 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
Re: $$Excel-Macros$$ Excel Pop-ups
Hey thanks it worked. Perfect solution Mahreen On Sun, Jun 19, 2011 at 11:59 AM, STDEV(i) wrote: > please check this vba code, hope it helps.. > > -Standard Module > > Sub ExpiryWarning() > ' siti Vi // Jakarta, 19 Jan 2011 > ' > Dim dTable As Range, t As String > Dim R As Long, N As Long, I As Integer > > Set dTable = Cells(1).CurrentRegion > N = dTable.Rows.Count > > For R = 2 To N > If IsDate(dTable(R, 5)) Then > I = dTable(R, 5) - Date > If I <= 15 Then > If I > 0 Then >dTable(R, 1).Resize(1, dTable.Columns.Count).Select >t = "Name : " & dTable(R, 2) & vbCr & vbCr >t = t & "Expiry Date : " & Format(dTable(R, 5), > "dd-mmm-") & vbCr & vbCr >t = t & "Number of days to come : " & Format(I, "0") & vbCr >MsgBox t, 48, "Warning" > End If > End If > End If > Next > Cells(1).Activate > End Sub > > -----Module Sheet1 > > Private Sub Worksheet_Activate() > ExpiryWarning > End Sub > > -Tiisworkbook Module > > Private Sub Workbook_Open() > ExpiryWarning > End Sub > > > > On Sun, Jun 19, 2011 at 12:25 AM, Mahreen Ellahi > wrote: > > Hii > > > > I have a some data with limits expiry on different dates. I want to have > > popup window to appear whenever the limit is about to expire like 15 to > 30 > > days earlier. Can anyone help me for VBA coding. > > > > Regards > > Mahreen > > -- > > -- > 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
$$Excel-Macros$$ Excel Pop-ups
Hii I have a some data with limits expiry on different dates. I want to have popup window to appear whenever the limit is about to expire like 15 to 30 days earlier. Can anyone help me for VBA coding. Regards Mahreen -- -- 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 Excel Popup.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Unsubscribe
Kindly unsubscribe me from the group. Extreme Regards Mahreen --~--~-~--~~~---~--~~ -- 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 6,500 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 -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Help needed : Excel Headers
Thankss it worked :-) On 4/9/09, Manoj S Negi wrote: > > Hi Mahreen, > > Follow the below mentioned procedure for the same. > 1. go to the file menu > 2. select page setup > 3. click on sheet tab > 4. there is option "Rows to repeat at top" click on that and give the range > of required field > 5. than come back by click on ok and print it. > > > > *Unfeigned Regards > Manoj S Negi > "Miles & miles to go before I sleep"* > *¨`·.·´¨) Always > `·.¸(¨`·.·´¨) Keep > (¨`·.·´¨)¸.·´ Smiling! > `·.¸.·´ > (¨`·.·´¨) (¨`·.·´¨) > `·.¸(¨`·.·´¨)¸.·´ > `·.¸.·«*:·. > .·:* > *:·. > *«*:·. > .·:* > *:·. > > * > On Thu, Apr 9, 2009 at 12:38 PM, Mahreen Ellahi < > mahreen.a...@googlemail.com> wrote: > >> I have few cells in excel worksheet that I want to show as header in print >> copy. Can any one tell me how to select those cells to show as print header. >> >> >> Regards >> Mahreen >> >> >> > > > > --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Urgent Help needed : Excel Headers
I have few cells in excel worksheet that I want to show as header in print copy. Can any one tell me how to select those cells to show as print header. Regards Mahreen --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help required
Can u tell me anyother freeware which helps convert pdf into word, excel and jpg files? On Sat, Dec 27, 2008 at 11:29 AM, Ajit Navre wrote: > Merry X'mas, > > > > If you are using Office 2003, or 2007, then MS itself provide for a PDF > AddIn. You just need to download it from the Microsoft download center. > Alternatively, try googling for *PDF Freeware* and you will find a lot of > freewares, to name a few SoftExpansion PDFlite, EasyPDF, CutePDF and a lot > more. All of these essentially create a virtual printer port (the PDF > converter) and let you create a PDF document from any application that has > print functionality. > > > > Regards > > > > Ajit. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Roshan Mathew > *Sent:* Saturday, December 27, 2008 3:28 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Help required > > > > Dear All, > > > > Hope you all had a good time during Christmas and Wish you all an Adv New > Year Wishes... > > > > Pls help me... > > > > I need to convert Excel or Word sheets into PDF formart and email the same > to different emails as per the list. > > > > > > -- > Roshan > > > > > > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Vlookup using multiple dependents (Ractified attachment)
Thanks alot for the link it is very helpful in thorough understanding of the formula On Mon, Nov 17, 2008 at 4:04 AM, Bertone, Joseph S. <[EMAIL PROTECTED]>wrote: > > Here you go- > Great step-by-step > (it takes a moment or two to load...) > > > http://blogs.msdn.com/excel/archive/2008/10/23/creating-a-master-detail-view-in-excel.aspx > > > > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: VLOOKUP with multiple dependents
Hey thanks alot all of you guys .. all the sheets serves my purpose but Ajit I found ur solution more easy to use ... Kamran yous solution is abit complicated but still thanks for the solution I'll try to understand it ... Many thanks to all Regards Mahreen On Mon, Nov 17, 2008 at 12:36 AM, Kamran Haider <[EMAIL PROTECTED] > wrote: > > > I found only one way may it works for you .Please inform me if it solve > your problem . > > > Allah Hafiz , > Kamran Haider . > > > > > > > -- > > Date: Sun, 16 Nov 2008 07:25:42 -0800 > From: [EMAIL PROTECTED] > > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ VLOOKUP with multiple dependents > > > Hi All > > I have a little query regarding VLOOKUP Formula. I have been using it > depending on only one value. But now I want to use for two dependents. The > attached file has two sheets one with the master data and the other one > where I extract data using VLOOKUP. > > *Customer No.* *Proposal No.* *Name* *Address* *Contact No.* > *Outstanding > Amount* *DPD* 360 1 Azhar ab 231 100 10 > > I am able to extract data with column named Customer No. but in my master > sheet I have same customer with several proposal no.s and their subsequent > different info. For instance there are 4 proposals in my master sheet for > customer no. 360. When I use vlookup, excel shows customer no. with only > proposal no. 1. I want to manually enter the customer & proposal no. in > column a2 & b2 respectively and the info shows should be of Customer no. 360 > with customer no. 1,2,3 or 4 (whichever specified in b2 by me). Kindly help > for the same as I have around 2000 enteries to work with. > Any help shall be appreciated. > > Regards > Mahreen > > > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ VLOOKUP with multiple dependents
Hi All I have a little query regarding VLOOKUP Formula. I have been using it depending on only one value. But now I want to use for two dependents. The attached file has two sheets one with the master data and the other one where I extract data using VLOOKUP. *Customer No.* *Proposal No.* *Name* *Address* *Contact No.* *Outstanding Amount* *DPD* 360 1 Azhar ab 231 100 10 I am able to extract data with column named Customer No. but in my master sheet I have same customer with several proposal no.s and their subsequent different info. For instance there are 4 proposals in my master sheet for customer no. 360. When I use vlookup, excel shows customer no. with only proposal no. 1. I want to manually enter the customer & proposal no. in column a2 & b2 respectively and the info shows should be of Customer no. 360 with customer no. 1,2,3 or 4 (whichever specified in b2 by me). Kindly help for the same as I have around 2000 enteries to work with. Any help shall be appreciated. Regards Mahreen --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~--- VLOOKUP.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Vlookup using multiple dependents (Ractified attachment)
Hi All I have a little query regarding VLOOKUP Formula. I have been using it depending on only one value. But now I want to use for two dependents. The attached file has two sheets one with the master data and the other one where I extract data using VLOOKUP. *Customer No.* *Proposal No.* *Name* *Address* *Contact No.* * Outstanding Amount * * DPD * 360 1 Azhar ab 231 1,000,000 10 I am able to extract data with column named Customer No. but in my master sheet I have same customer with several proposal no.s and their subsequent different info. For instance there are 4 proposals in my master sheet for customer no. 360. When I use vlookup, excel shows customer no. with only proposal no. 1. I want to manually enter the customer & proposal no. in column a2 & b2 respectively and the info shows should be of Customer no. 360 with customer no. 1,2,3 or 4 (whichever specified in b2 by me). Kindly help for the same as I have around 2000 enteries to work with. Any help shall be appreciated. Regards Mahreen --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~--- VLOOKUP(1).xls Description: MS-Excel spreadsheet
