Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-06-29 Thread amar takale
Dear Lalitji Can any suggestion on this topic? On Fri, Jun 27, 2014 at 4:16 PM, amar takale wrote: > Dear Lalit bro.. > > Thanks for this good one code but it is only for mkt cap column & i > required this filter for total Row no 7 means all field (If add other > criteria field in row 7). > So p

Re: $$Excel-Macros$$ Sort VBA Code Modified

2014-06-29 Thread amar takale
Dear latit mohan, when i use above code which you provide show error "object does not support this property or method" in excel.Pls give me proper guidance Regards Amar On Mon, Jun 30, 2014 at 10:17 AM, amar takale wrote: > Dear Bé Trần Văn > > Thanks very much sir. but i ask you small is

Re: $$Excel-Macros$$ Sort VBA Code Modified

2014-06-29 Thread amar takale
Dear Bé Trần Văn Thanks very much sir. but i ask you small issue can we use one code to all filed like lalit mohanji code.I use this code but erroe show "object does not support this property or method" Thanks once again Regards Amar On Sat, Jun 28, 2014 at 3:34 PM, Bé Trần Văn wrote

Re: $$Excel-Macros$$ Help required on Macro

2014-06-29 Thread Jocky Beta
Hi Team, Can anybody help me for converting above attached file to comfortable for office 2010 as this file is made in office 2007 and its not working in office 2010 Regards On 6/27/14, Jocky Beta wrote: > -- Forwarded message -- > From: Abhishek Jain > Date: Thu, 26 Jun 2014

Re: $$Excel-Macros$$ Need a help in Pivot

2014-06-29 Thread Bé Trần Văn
You use to track away for all year. Need something to filter or retrieves the competition, it will be very convenient for you. 2014-06-29 15:11 GMT+07:00 Prabhu Pinky : > Once you done the pivot...you can unselect the OFF from list...so that you > will get the count excluding OFF... > On 29-J

Re: $$Excel-Macros$$ Select cells based on custom format

2014-06-29 Thread Vaibhav Joshi
Hi You can create a button on main sheet to run macro. Create button or image and right click on it to assign macro. Cheers On Jun 29, 2014 5:43 PM, "Vijayendra Rao" wrote: > Dear Vaibhav, > > Thanks for your solution, it's working fine. Is there any other way to > select those cells or convert

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-06-29 Thread Kalpesh Shivdas
Hi Vaibhav this format is almost fixed means first Opening Balance then current bill & the receipt against it then interest (calculate by macros) & then closing outstanding/ advance by experience I know during the period not more than 3 receipt received if macros can calculate more than receipt i

Re: $$Excel-Macros$$ Select cells based on custom format

2014-06-29 Thread Vijayendra Rao
Dear Vaibhav, Thanks for your solution, it's working fine. Is there any other way to select those cells or convert cells without macros. 2014-06-28 11:13 GMT+05:30 Vaibhav Joshi : > Hi > > I have created macro, goto sheet 2, press Alt + F8 and press enter to get > what you want. > > Cheers!!

Re: $$Excel-Macros$$ Need a help in Pivot

2014-06-29 Thread Prabhu Pinky
Once you done the pivot...you can unselect the OFF from list...so that you will get the count excluding OFF... On 29-Jun-2014 12:18 PM, "Ganesh N" wrote: > Hi, > > Thank. But there is any way to get the details without changing the > structural ? > > Because the initial one is the format which us

Re: $$Excel-Macros$$ Excel Macros for Interest Calculation

2014-06-29 Thread Vaibhav Joshi
Hi Is this format is fixed or subject to change? If format is fixed then is if by chance you get more than 3 receipts than what? What you want Macro to do? Where you want calculated Interest amount to be shown in sheet? Cheers!! On Sat, Jun 28, 2014 at 12:15 PM, Kalpesh Shivdas wrote: > Hi