Re: $$Excel-Macros$$ discussexcel.com Launched today

2011-03-22 Thread girish kumar
Hi Ayush, Congrats my friend Regards Girish On Tue, Mar 22, 2011 at 10:52 AM, Umesh Dev wrote: > Hi Ayush, > > Congrats to you and the team. > > Regards > Umesh > > > On Mon, Mar 21, 2011 at 10:08 PM, neil johnson > wrote: > >> Hi , >> Congratulation to you sir >> On 3/20/11, Ayush Jain wro

Re: $$Excel-Macros$$ Macro to Average a series of numbers in excel

2011-03-22 Thread Dilip Pandey
Oopss...!! Quick Solution:- Create a sheet by the name of "backup" in your workbook and that's all. All functionality should work fine. Best Regards, DILIPandey On 3/22/11, Pehrson, Dave wrote: > Dilip, need a little more help, I took your latest update program > logic and pasted into an upda

$$Excel-Macros$$ RE: Google Groups: You've been added to MS EXCEL AND VBA MACROS

2011-03-22 Thread Girish Sherigar
Hi Ayush, Thank you very much.. Thanks & Best Regards, Girish GVS - VSDB Phone: 91 22 66591584 Direct Kind words can be short and easy to speak, but their Echoes are truly endless. -Original Message- From: nore...@googlegroups.com [mailto:nore...@googlegroups.com] Sent: Tuesday, March 2

Re: $$Excel-Macros$$ how to prevent from duplicate value?

2011-03-22 Thread Muhammad Talal Akbar
First of all i m very thankful to you 4 your quick response. but dear that is very difficult one for me becoz i have no knowledge about this language. plz help me in easiest way i am waiting your quick response. regards On Tue, Mar 22, 2011 at 12:23 PM, ashish koul wrote: > > try this > > >

$$Excel-Macros$$ Is there any carrer in excel.

2011-03-22 Thread Bhushan
Dear Expert, 1. Is there any carrer in excel,This there good demand for excel knowledge in reputed company. 2. Is any scope in further growth as MIS. 3. Is there any course or institute related to MIS. 4. Because i am in MIS feild for prv 1.5 years the above question have asked

RE: $$Excel-Macros$$ Need coding help!

2011-03-22 Thread Dave Bonallack
Hi Sandra, I may be a bit dim tonight, but it's not clear to me if the data sample you provided is the format you want, or the format you currently have. If this is the format you currently have, what format do you want? If this is the format you want, what format do you currently have? Regards -

Re: $$Excel-Macros$$ Is there any carrer in excel.

2011-03-22 Thread Sanjoy Nath
great scopes Excel breaks all Domains and enters everywhere On Tue, Mar 22, 2011 at 2:37 PM, Bhushan wrote: > Dear Expert, > > 1. Is there any carrer in excel,This there good demand for excel > knowledge in reputed company. > 2. Is any scope in further growth as MIS. > 3. Is the

$$Excel-Macros$$ Re: Need coding help!

2011-03-22 Thread Bhushan Sabbani
HI Sandra, Please attached the example file so i can help you. The concept of your is clear if you provide the example file so i can the help. Warm Regards, Bhushan Sabbani +91 98208 26012 -- -- Some important lin

$$Excel-Macros$$ Re: Please Help

2011-03-22 Thread Bhushan Sabbani
Hi Sudhir, Use the below formula for the running balance =SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25) I am not clear where are you getting the pending amount. Please clear the same so i can help regarding the same. Warm Regards, Bhushan Sabbani +91 98208 26012 --

$$Excel-Macros$$ Re: Please Help

2011-03-22 Thread sudhir kumar
Thanking You On 22 March 2011 13:44, Bhushan Sabbani wrote: > Hi Sudhir, > > Use the below formula for the running balance > =SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25) > > I am not clear where are you getting the pending amount. > > Please clear the same so i can help regarding the same. > >

$$Excel-Macros$$ Re: i need a help

2011-03-22 Thread Bhushan Sabbani
Dear Vijay, Pls find the solution file. Warm Regards, Bhushan Sabbani -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Lin

$$Excel-Macros$$ Re: Please Help

2011-03-22 Thread sudhir kumar
Please Can u give me explanation to this formula. On 22 March 2011 14:57, sudhir kumar wrote: > Thanking You > > > On 22 March 2011 13:44, Bhushan Sabbani wrote: > >> Hi Sudhir, >> >> Use the below formula for the running balance >> =SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25) >> >> I am not c

$$Excel-Macros$$ EMI Calculator

2011-03-22 Thread Ayush
Hello Everyone, I have posted EMI Calculator Template on discussexcel.com. Download and Keep a copy with you always as lots of the things are purchased on EMI. Visit the templates section to download the same. http://www.discussexcel.com/downloads Thanks. Regards Ayush Jain -- -

Re: $$Excel-Macros$$ Find all NamedRanges in Worksheet/workbook

2011-03-22 Thread hanumant shinde
Thanks again. @ STDEV sorry but ur code is not working its throwing error for Cells(r, 2) = nm.address(false, false). i dont know if i need to make any change in your code. @All, i have just started working on NameRanges so dont have much idea about it. IĀ face 1 more problem which is as follo

Re: $$Excel-Macros$$ Find all NamedRanges in Worksheet/workbook

2011-03-22 Thread ashish koul
try this Sub name_rngs() Dim x As Name Dim z As String i = 1 For Each x In ActiveWorkbook.Names z = "" Sheets(4).Cells(i, 1) = x.Name z = Replace(x.RefersTo, "=", "") Sheets(4).Cells(i, 2) = Replace(z, "$", "") i = i + 1 Next x End Sub On Tue, Mar 22, 2011 at 11:02 PM, hanumant shinde wro

$$Excel-Macros$$ Bug Rectification required for Random Data Selection Macro

2011-03-22 Thread RKMaariappan
Note~ Sample file already attached with the mail which I sent on 18th march 2011 for the same Subject Line. HI Team, I have written a code for selecting random data from master data. Please find the checkpoints below. Data Format: Master Data will have n number of records. Each Row will have 4 c

Re: $$Excel-Macros$$ EMI Calculator

2011-03-22 Thread Nandkumar kakvipure
page not open plzz post correct link On Tue, Mar 22, 2011 at 8:34 PM, Ayush wrote: > Hello Everyone, > > I have posted EMI Calculator Template on discussexcel.com. > > Download and Keep a copy with you always as lots of the things are > purchased on EMI. > > Visit the templates section to downlo

$$Excel-Macros$$ Re: Please Help

2011-03-22 Thread Bhushan Sabbani
=SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25) The subtotal is the function which update the sum of number is the filter is done. See the attached file of the clear understanding. When you drag the formula,As e24 ref. is absolute it won't change. remaiming refrence keep on changing. Warm Regar

$$Excel-Macros$$ Re: Help in Excel

2011-03-22 Thread Bhushan Sabbani
Dear, Please find the attached solved file for the same. Please let me know was that solution helpful. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITT

$$Excel-Macros$$ hello all, its very urgent;;;

2011-03-22 Thread vijayajith VA
Hello all, Please can you tell me what is dashboard? can you give some examples with excelsheet? if you have examples can you mail me? please please;;; thankyou vijay -- -- Some important links for excel users: 1

Re: $$Excel-Macros$$ EMI Calculator

2011-03-22 Thread Ayush
Hi Nandu, The path is fine. 50+ members already downloaded successfully. Let me know the path you are using. Regards Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks an

$$Excel-Macros$$ Re: hello all, its very urgent;;;

2011-03-22 Thread Ayush
Hi Vijay, To learn more on dashboards, Visit Dashboardspy.com I hope it helps. Going Forward, Please use the relevant subject line for quick attention of forum experts. Thanks Regards Ayush Jain -- -- Some import