Re: $$Excel-Macros$$ Re: Long List problem

2010-11-26 Thread Manish Pansari
Any help pls On Nov 25, 10:53 am, Manish Pansari pansari.man...@gmail.com wrote: Hi Paul, Thanks a ton for your help. I am financial guy and I know only 20% coding in VBA. I am on the way to learn VBA. I get an idea with following code. I need one textbox in same form above the

Re: $$Excel-Macros$$ How to extract characters from right

2010-11-26 Thread Rajasekhar Praharaju
hi Kalyan, Use substitute function. Please find the attached solution hope it helps you. Thanks, Raj On Fri, Nov 26, 2010 at 10:55 AM, Kal xcel kalx...@gmail.com wrote: Dear Experts, I am facing a problem to extract characters from right of string. Please help. Thanks in advance.

RE: $$Excel-Macros$$ copy range to other sheet but split it to 3 column

2010-11-26 Thread عمــــــــــــر
Yes yes Very god But I want it by code I want three column in one row And three column in the next row And three column in next row Thanks for help From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of roberto mensa Sent: Friday, November 26,

Re: $$Excel-Macros$$ copy range to other sheet but split it to 3 column

2010-11-26 Thread roberto mensa
2010/11/26 عمر omar27...@gmail.com Yes yes Very god But I want it by code Sub test() Dim rng1 As Excel.Range Dim rng2 As Excel.Range On Error Resume Next Set rng1 = Intersect(ActiveSheet.UsedRange, Range(A:A)) Set rng1 = Application.InputBox( _ Select series, _

Re: $$Excel-Macros$$ Nonlinear Regression Analysis

2010-11-26 Thread Dilip Pandey
Hi Bob, Ok, in order to determine the best Singular X and Y values we need to break down or segregate the large data into the similar type of data sets. After this segregation we can have 2 or 3 sets of Singular Xs and Ys which can be used to fulfill / justify the equation as one set of X and Y

Re: $$Excel-Macros$$ Salary sending problem

2010-11-26 Thread Ankit Agrawal
Namste Vaibhav ji, *Unbelievable task. *how I tell you what you are? but sir after clicking it, it add sheet and creating the file as well. but not saving it and occurring a error. so please implement it also. Thanks Regards Ankit On Fri, Nov 26, 2010 at 8:37 PM, in.vaib...@googlemail.com

Re: $$Excel-Macros$$ Nonlinear Regression Analysis

2010-11-26 Thread Bob
I am OK with three different x and y values ... I'm not sure why that never occurred to me! Would it help to send you ALL of the data together? On Nov 26, 9:22 am, Dilip Pandey dilipan...@gmail.com wrote: Hi Bob, Ok, in order to determine the best Singular X and Y values we need to break

Re: $$Excel-Macros$$ Salary sending problem

2010-11-26 Thread in . vaibhav
Dear Ankit, File is saved in C:/Payslip folder. Sent on my BlackBerry® from Vodafone -Original Message- From: Ankit Agrawal ankit.agrawal...@gmail.com Date: Sat, 27 Nov 2010 08:37:47 To: in.vaib...@googlemail.comin.vaib...@gmail.com Cc: excel-macros@googlegroups.com Subject: Re:

Re: $$Excel-Macros$$ Salary sending problem

2010-11-26 Thread Mohammed Abdulkaleem
HI, User want to display SAP BI Query in Excel sheet. what is the procedure, Please send the steps. On Fri, Nov 26, 2010 at 9:29 AM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Thanks Vaibhav, It was great but I discussed with my boss. He said we need salary slip in separate files so