Re: $$Excel-Macros$$ Pivot Table (URGENT)

2012-01-20 Thread Mahreen Ellahi
PM, Mahreen Ellahi mahreen.acc...@gmail.com 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

$$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread Mahreen Ellahi
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

Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread Mahreen Ellahi
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

Re: Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread Mahreen Ellahi
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

Re: Re: Re: Re: $$Excel-Macros$$ Font size in drop-down menu

2011-11-10 Thread Mahreen Ellahi
reference from 4 to match your worksheet On , Mahreen Ellahi mahreen.acc...@gmail.com 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

Re: $$Excel-Macros$$ Help

2011-11-04 Thread Mahreen Ellahi
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 samde...@gmail.comwrote: So did you check my post? Sam On Thu, Nov 3, 2011 at 10:03 PM, Mahreen Ellahi mahreen.acc...@gmail.comwrote: I want the user either

Re: $$Excel-Macros$$ Help

2011-11-03 Thread Mahreen Ellahi
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,

Re: $$Excel-Macros$$ Help

2011-11-03 Thread Mahreen Ellahi
Guillett SalesAid Software dguille...@gmail.com *From:* Mahreen Ellahi mahreen.acc...@gmail.com *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

$$Excel-Macros$$ Help

2011-11-01 Thread Mahreen Ellahi
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

Re: $$Excel-Macros$$ Help

2011-11-01 Thread Mahreen Ellahi
: 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 mahreen.acc...@gmail.comwrote: Guys I have some

Re: $$Excel-Macros$$ Excel Pop-ups

2011-06-19 Thread Mahreen Ellahi
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 mahreen.acc...@gmail.com wrote

$$Excel-Macros$$ Excel Pop-ups

2011-06-18 Thread Mahreen Ellahi
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 --

$$Excel-Macros$$ Unsubscribe

2009-10-05 Thread Mahreen Ellahi
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

$$Excel-Macros$$ Urgent Help needed : Excel Headers

2009-04-09 Thread Mahreen Ellahi
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 --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: VLOOKUP with multiple dependents

2008-11-17 Thread Mahreen Ellahi
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