$$Excel-Macros$$ Help
Hi All, Can anyone help me on this by using index function. I have a drop down where i click on the required and i need to get the subset details of those drop down Thanks Prasad -- -- 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 Doubt.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Help
Dear Surya, Please see attached sheet -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Oct 17, 2011 at 4:54 PM, suryaprasad.bv suryaprasad...@gmail.comwrote: Hi All, Can anyone help me on this by using index function. I have a drop down where i click on the required and i need to get the subset details of those drop down Thanks Prasad -- -- 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 Doubt(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ auto complete feature in drop down list or combo box
You can tie to a worksheet_change event in the sheet module. More info and/or share a file Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: ajjw123 Sent: Sunday, October 16, 2011 8:14 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ auto complete feature in drop down list or combo box can anybody help me with auto complete feature incorporation in drop down list or in a combo box.thanks -- -- 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$$ auto complete feature in drop down list or combo box
Please share your worksheet with us. On Mon, Oct 17, 2011 at 6:44 AM, ajjw123 ajjw...@gmail.com wrote: can anybody help me with auto complete feature incorporation in drop down list or in a combo box.thanks -- -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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$$ Get the Unique value from pivot table in combo box
Hello, I have a pivot table which is dynamic which is going to be change every time when i open the workbook i want to get the unique value from pivot table field in combo box add item. lets example : my pivot table field is Agent name there are several agent who work repetedly till 4 rows so i need to get the unique vallue in combo box item PIVINT TBALE FIELD Agent:COMBOBOX DROUP DOWN A A A D D R D D D D R -- -- 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$$ Help
Hi Noorain, Could you plz make me understand how has it been done? Thanks Regards, Ankit On Mon, Oct 17, 2011 at 5:27 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Surya, Please see attached sheet -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 17, 2011 at 4:54 PM, suryaprasad.bv suryaprasad...@gmail.com wrote: Hi All, Can anyone help me on this by using index function. I have a drop down where i click on the required and i need to get the subset details of those drop down Thanks Prasad -- -- 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
$$Excel-Macros$$ Sample Feasibility Report
Hi Excel Group Members, I was hoping if anyone can share project feasibility report (sample) specifically for real estate in Indian Context. I have to work on feasibility study of a township project. This may carry following details - 1. Profitability Statement (Feasibility) 2. Cash Inflow / Outflow 3. Product Mix categories / Market Statistics Though I would be more than happy to prepare a template myself, but this report is required on urgent basis, so if any of you can be of help. Pl. -- -- 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$$ Quick Date Count Question
I'm trying to determine if a specific date falls between a start and end date. For example: A1: 9/7/2011 B1: 9/28/2011 C1: 11/2/2011 If A1 is between B1 and C1, then return a 1 if not, then return a zero. Seems like it would be easy, but been scratching my head on this too long. Thanks! -- -- 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$$ Quick Date Count Question
Since you have only specified between B1, and C1, and not whether B1 will always be lesser than C1, here's a generic formula. =IF(AND(A1=MIN(B1,C1),A1=MAX(B1,C1)),1,0) Regards, Sam Mathai Chacko On Mon, Oct 17, 2011 at 8:38 PM, RockyFontane vtorral...@gmail.com wrote: I'm trying to determine if a specific date falls between a start and end date. For example: A1: 9/7/2011 B1: 9/28/2011 C1: 11/2/2011 If A1 is between B1 and C1, then return a 1 if not, then return a zero. Seems like it would be easy, but been scratching my head on this too long. Thanks! -- -- 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 -- Sam Mathai Chacko -- -- 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$$ Quick Date Count Question
Hi Try this =if(and(a1b1,a1c1),a1,0) Thanks and Regards, Somnath C Pardeshi Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: RockyFontane vtorral...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 17 Oct 2011 08:08:40 To: MS EXCEL AND VBA MACROSexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Quick Date Count Question I'm trying to determine if a specific date falls between a start and end date. For example: A1: 9/7/2011 B1: 9/28/2011 C1: 11/2/2011 If A1 is between B1 and C1, then return a 1 if not, then return a zero. Seems like it would be easy, but been scratching my head on this too long. Thanks! -- -- 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$$ Count days in a Col
Hi All, I have three different dates in a Column A , suppose say in Col A i have A1 as 1- Dec -2010, A2 as 11- Jan-2011,A3 as 1- Mar -2011 then i need a count of number days as *3* in the cell A4 any idea? Thanks Prasad. -- -- 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$$ Help
Dear Ankit, Please see attached sheet with explain Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Oct 17, 2011 at 7:06 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Hi Noorain, Could you plz make me understand how has it been done? Thanks Regards, Ankit On Mon, Oct 17, 2011 at 5:27 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Surya, Please see attached sheet -- On Mon, Oct 17, 2011 at 4:54 PM, suryaprasad.bv suryaprasad...@gmail.com wrote: Hi All, Can anyone help me on this by using index function. I have a drop down where i click on the required and i need to get the subset details of those drop down Thanks Prasad -- -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- 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 Doubt(Explain).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Count days in a Col
Unless I'm mistaken, is this what you are looking for? =COUNT(A1:A3) Regards, Sam Mathai Chacko (GL) On Mon, Oct 17, 2011 at 8:50 PM, Mr Excellent suryaprasad...@gmail.comwrote: Hi All, I have three different dates in a Column A , suppose say in Col A i have A1 as 1- Dec -2010, A2 as 11- Jan-2011,A3 as 1- Mar -2011 then i need a count of number days as *3* in the cell A4 any idea? Thanks Prasad. -- -- 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 -- Sam Mathai Chacko -- -- 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$$ Quick Date Count Question
try =if(and(a1=b1,a1c1),1,) Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: RockyFontane Sent: Monday, October 17, 2011 10:08 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Quick Date Count Question I'm trying to determine if a specific date falls between a start and end date. For example: A1: 9/7/2011 B1: 9/28/2011 C1: 11/2/2011 If A1 is between B1 and C1, then return a 1 if not, then return a zero. Seems like it would be easy, but been scratching my head on this too long. Thanks! -- -- 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$$ Count days in a Col
Dear Surya, SAM is right but If you want to Count only Date Please try it and see attached sheet..i hope it will help to u Function Countonly_date(rng As Range) For Each abc In rng If IsDate(abc) Then Countonly_date = Countonly_date + Application.WorksheetFunction.CountA(abc) End If Next End Function -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Oct 17, 2011 at 8:50 PM, Mr Excellent suryaprasad...@gmail.comwrote: Hi All, I have three different dates in a Column A , suppose say in Col A i have A1 as 1- Dec -2010, A2 as 11- Jan-2011,A3 as 1- Mar -2011 then i need a count of number days as *3* in the cell A4 any idea? Thanks Prasad. -- -- 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 Count_Only_Date.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Un lock the file.
Dear Jay, Please try through below link. http://www.straxx.com/excel/password.html -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Mon, Oct 17, 2011 at 7:40 PM, jayendra gaurav jayendra.gau...@gmail.comwrote: Pls help me in this. -- Forwarded message -- From: jayendra gaurav jayendra.gau...@gmail.com Date: Fri, Oct 14, 2011 at 1:19 PM Subject: $$Excel-Macros$$ Un lock the file. To: excel-macros@googlegroups.com Dear Team, I forgot the password of this file .kindly unlock the same Its very urgent. Regards J.Gaurav -- -- 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 -- J.Gaurav Operation Manager Mahindra logistics General Motor Hallol Baroda Cell - 9327348097 -- -- 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$$ Un lock the file.
That will only open the sheet / workbook password Noorain :) On Mon, Oct 17, 2011 at 9:29 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Jay, Please try through below link. http://www.straxx.com/excel/password.html -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 17, 2011 at 7:40 PM, jayendra gaurav jayendra.gau...@gmail.com wrote: Pls help me in this. -- Forwarded message -- From: jayendra gaurav jayendra.gau...@gmail.com Date: Fri, Oct 14, 2011 at 1:19 PM Subject: $$Excel-Macros$$ Un lock the file. To: excel-macros@googlegroups.com Dear Team, I forgot the password of this file .kindly unlock the same Its very urgent. Regards J.Gaurav -- -- 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 -- J.Gaurav Operation Manager Mahindra logistics General Motor Hallol Baroda Cell - 9327348097 -- -- 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 -- Sam Mathai Chacko -- -- 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$$ Get the Unique value from pivot table in combo box
Hello, I have a pivot table which is dynamic which is going to be change every time when i open the workbook i want to get the unique value from pivot table field in combo box add item. lets example : my pivot table field is Agent name there are several agent who work repetedly till 4 rows so i need to get the unique vallue in combo box item -- -- 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$$ Paste into a Named Range
Hi I have a 2 cells in a row that I want to copy into a named range (say 'serialNo') also only 2 columns. Do I have to do the vba xcell up routine ? or should I be able to paste into 'serialno' and it will go into next available row. I have tried recording copy/paste, select 'serialno' but not successful. Thanks Charlie Harris -- -- 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$$ Toggle a Cell value
Hi Sam Works very well. Thankyou Sam and Don for your inputs. REgards Charlie On Sun, Oct 16, 2011 at 9:55 PM, Sam Mathai Chacko samde...@gmail.comwrote: I don't necessarily support this alternative, and I don't think it is popular among the old schools either, but it is effective nonetheless. There is a certain Hyperlink event which could be modified to bamboozle Excel and make it work to your advantage. The trick is to create a hyperlink to the same cell from within itself, and then use the event macro. I have attached a modified version of the same here. The green line is just added as an embellishment. You can ignore that if not needed. *Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) With Target.Parent If .Address(0, 0) = G15 Then Target.ScreenTip = Click to reverse direction of the motor .Value = Abs(CLng(Not -.Value)) End If End With End Sub Regards, Sam Mathai Chacko (GL) * On Sun, Oct 16, 2011 at 12:06 PM, Cab Boose swch...@gmail.com wrote: Hi Don Sam Don. appreciate your comment. I had not made it clear what I was looking for. Apologies. Sam, yes it is working great with dbl click or right click. It does not work with a single click, which is what I prefer. In use the cell would be selected and then may also need to click once again to change the cell to requirement. Your comments would be appreciated. Thanks Charlie Harris On Sun, Oct 16, 2011 at 12:13 AM, dguillett1 dguille...@gmail.comwrote: Your request was “when I SELECT the cell”. So, as Sam says, use another event such as doubleclick. Don Guillett SalesAid Software dguille...@gmail.com *From:* Cab Boose swch...@gmail.com *Sent:* Friday, October 14, 2011 8:32 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Toggle a Cell value Hi Don and Sam Thanks for your input. I use Win7 Excel and on a laptop. Don, your code work ok but small hiccup. The code/color changes ok when I select a different cell and then come back to actual cell again. Color and number change as required. However I would like to be able to leave the cursor in the active cell, somethimes, and each time I tap the cell on the laptop pad, it should change. That is without having to go to another cell first. In other words how do you get Excel to know when you select cell and then select again without moving. Maybe if we can after the first selection and change of color/code Excel places the active cell into a default cell nearby, and if the direction needs to be changed again I need to select that cell again. Or is there a way of refreshing the g15 cell without moving. Sam, your code brings up a run time error '13' type mismatch. The color is ok by format, but does the code allow for changing the value in the cell back and forth from 1 to 0 and 0 to 1 . Thankyou all Charlie Harris On Sat, Oct 15, 2011 at 6:36 AM, Sam Mathai Chacko samde...@gmail.comwrote: This should do it Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address(0, 0) = G15 Then Target.Value = Abs(CLng(Not -Target.Value)) End If End Sub Use a conditional format for coloring the cell. If you do not want to add a conditional format (which is faster than VBA by the way), and do the coloring also through VBA, then just add the following line within the If End IF statement in the VBA above. Target.Interior.ColorIndex = 4 - Target.Value Regards, Sam Mathai Chacko On Fri, Oct 14, 2011 at 6:09 PM, dguillett1 dguille...@gmail.comwrote: Right click sheet tabview codecopy/paste this to make the changes in col G Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column 7 Or Target.Count 1 Then Exit Sub If Target = 1 Then Target = 0 Target.Interior.ColorIndex = 4 Else Target = 1 Target.Interior.ColorIndex = 3 End If End Sub Don Guillett SalesAid Software dguille...@gmail.com *From:* Cab Boose swch...@gmail.com *Sent:* Friday, October 14, 2011 2:33 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Toggle a Cell value Hi eveyrone See attached sheet. For a 12 volt motor speed direction, Forward or Reverse I want to have a value of a cell to toggle back and forth between 0 and 1 and cell color also to change each time between green and red. Prefer to use a cell than use a toggle button, unless a toggle button can change colors etc and the value of 0 or 1 from the toggle button can be used to export etc Your comments would be appreciated. Charlie Harris -- -- 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
Re: $$Excel-Macros$$ Paste into a Named Range
please attach example file 2011/10/17 Cab Boose swch...@gmail.com Hi I have a 2 cells in a row that I want to copy into a named range (say 'serialNo') also only 2 columns. Do I have to do the vba xcell up routine ? or should I be able to paste into 'serialno' and it will go into next available row. I have tried recording copy/paste, select 'serialno' but not successful. Thanks Charlie Harris -- -- 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 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- 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$$ Paste into a Named Range
If you have a defined name range such as myrng defined using this, then if you drag to col A it will extend the named range to accommodate the new data. assumes numbers. If numbers in col A, use 99 or any number greater than you might use =OFFSET(Sheet1!$A$2,0,0,MATCH(,Sheet1!$A:$A),2) Don Guillett SalesAid Software dguille...@gmail.com From: Cab Boose Sent: Monday, October 17, 2011 5:57 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Paste into a Named Range Hi I have a 2 cells in a row that I want to copy into a named range (say 'serialNo') also only 2 columns. Do I have to do the vba xcell up routine ? or should I be able to paste into 'serialno' and it will go into next available row. I have tried recording copy/paste, select 'serialno' but not successful. Thanks Charlie Harris -- -- 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$$ Get the Unique value from pivot table in combo box
Hi, http://datapigtechnologies.com/blog/index.php/recordset-tricks-in-excel-1-filling-a-combobox-with-unique-values/ Hope these link help u better. On Mon, Oct 17, 2011 at 11:03 PM, ICWAI Help icwai.answ...@gmail.comwrote: Hello, I have a pivot table which is dynamic which is going to be change every time when i open the workbook i want to get the unique value from pivot table field in combo box add item. lets example : my pivot table field is Agent name there are several agent who work repetedly till 4 rows so i need to get the unique vallue in combo box item -- -- 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 -- B.N Chetan kumar -- -- 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$$ Paste into a Named Range
Hi Don and ChilExcel Thanks for info. Don like earlier I have not put enough info. I should learn from this. See attached workbook with comments. Thanks, apologies and regards Charlie Harris On Tue, Oct 18, 2011 at 12:29 PM, dguillett1 dguille...@gmail.com wrote: If you have a defined name range such as myrng defined using this, then if you drag to col A it will extend the named range to accommodate the new data. assumes numbers. If numbers in col A, use 99 or any number greater than you might use =OFFSET(Sheet1!$A$2,0,0,MATCH(,Sheet1!$A:$A),2) Don Guillett SalesAid Software dguille...@gmail.com *From:* Cab Boose swch...@gmail.com *Sent:* Monday, October 17, 2011 5:57 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Paste into a Named Range Hi I have a 2 cells in a row that I want to copy into a named range (say 'serialNo') also only 2 columns. Do I have to do the vba xcell up routine ? or should I be able to paste into 'serialno' and it will go into next available row. I have tried recording copy/paste, select 'serialno' but not successful. Thanks Charlie Harris -- -- 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 PasteToNamedRg.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Help
Here's an accurate list. Regards, Sam Mathai Chacko (GL) On Mon, Oct 17, 2011 at 8:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Ankit, Please see attached sheet with explain Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Oct 17, 2011 at 7:06 PM, Ankit Agrawal ankit.agrawal...@gmail.com wrote: Hi Noorain, Could you plz make me understand how has it been done? Thanks Regards, Ankit On Mon, Oct 17, 2011 at 5:27 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Surya, Please see attached sheet -- On Mon, Oct 17, 2011 at 4:54 PM, suryaprasad.bv suryaprasad...@gmail.com wrote: Hi All, Can anyone help me on this by using index function. I have a drop down where i click on the required and i need to get the subset details of those drop down Thanks Prasad -- -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- 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 -- Sam Mathai Chacko -- -- 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 Doubt.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Help
Hello Surya; If your data is sorted by Country in Ascending order, use the file sorted_by_Country. The other one will work with sorted or unsorted data. Also used dynamic range. HTH Haseeb -- -- 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 Sorted_by_Country.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet Unsorted_Data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Excel/VBA programmer-Midtown Manhattan (Hottest Position)
** * * * Hi Friends, Hope you are doing well today. Please find the job description below and send me the updated resume at ASAP. Here is an Immediate interview for the position. (Please send resumes to vi...@addonusa.com) Name: Contact: E-Mail: Location: Re-Location: Visa: Availability: Rate: _ A global investment bank located in Midtown Manhattan is in need of a excel/VBA programmer to work within their market risk team Length: 6 Months+ Location: Midtown Manhattan Job Description - Design/implement data model and risk reporting tools for limit monitoring, back testing, capital calculation, stress testing, capital calculation, Risk identification, capture and assessment process - Participate in analysis and testing of Global strategic risk calculation and aggregation engines and components; - Improve current modules with more standardization, robustness and efficiency. Potentially apply the tools for wider usage across sites and regions - Work with users on software support, testing and maintenance issues - Write functional spec, technical design/implementation and user guide papers Skills / Qualifications: - Ideally 3-5 years of experience in financial services industry. - Expert in SQL/Sybase; Experience in data model design - Solid Excel/VBA programming skills and experience - Knowledge of market risk measures and experience in market risk systems is preferred - Familiar with Java/Web programming is a plus - Excellent verbal and written skills are a must. Must be able to explain complex and/or technical matters clearly, accurately and simply. Frequent interactions with market risk and credit risk managers, product controllers, and senior IT developers. Timely feedback and escalation to line manager. - Think out-of-the-box and be creative in software solutions with the target and time-constraint in perspective - Organized, detail-oriented and self-motivated quick learner and starter. Ability to work in a team and develop maintain relationships. - Proactive and dynamic, be able to work on multiple projects simultaneously and address ad-hoc requirements in an open, accurate and timely manner - Exposure to financial products and risks are preferred; Experience in risk reporting and design is a plus - Excellent educational background in computational or quantitative field (Computer Science, Math, Physics, Financial Engineering) is preferable. Thanks Regards Vinod ADDON Technologies, Inc. Direct: 734-956-4737 Ext - 163 Fax: 734-418-2603 Mail ID: vi...@addonusa.com IM:vinod.addontech URL: www.addonusa.com [image: cid:image001.png@01CC5CA0.7061C480] Note: We at Addon Technologies respect your On-line Privacy. Under Bills.1618, Title III passed by the 105th U.S. Congress this mail cannot be considered spam as long as we include contact information and a remove link for removal from our mailing list, so we do not believe this email is unsolicited. If you do not wish to receive our e-mails and/or lists, click on the link below and press SEND: mailto:jos...@addonusa.com?subject=Remove_me.Pleasejos...@addonusa.com?subject=Remove_me.Pleasereply from the exact address to which this was originally mailed to or provides the address (es) to be removed. Any inconvenience caused is regretted. * -- -- 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$$ conditional formatting- more than 3
Hi I am xavier, new to this group. Please help me in conditional formatting i use excel 2003 and it does not allow more than 3 conditions. Someone can help please Many Thanks Xavier -- -- 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$$ Sum Product Sheet
Dear Sirs, Please provide me sumproduct functions sheet which having different example in it. @Noorain Ansari sir, Looking your help also. Thanks Regards, Ankit -- -- 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$$ conditional formatting- more than 3
http://chandoo.org/wp/2008/10/14/more-than-3-conditional-formats-in-excel/ http://en.kioskea.net/forum/affich-21716-conditional-formatting-more-than-3-in-excel On Tue, Oct 18, 2011 at 9:04 AM, Kuts xavierj...@gmail.com wrote: Hi I am xavier, new to this group. Please help me in conditional formatting i use excel 2003 and it does not allow more than 3 conditions. Someone can help please Many Thanks Xavier -- -- 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 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- -- 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