Re: $$Excel-Macros$$ Re: to pickup only require number or word

2017-06-14 Thread Mahesh Patil
Explain your requirement in more details. On Wed, Jun 14, 2017 at 9:53 AM, pskachhaw...@gmail.com < pskachhaw...@gmail.com> wrote: > > > On Tuesday, June 13, 2017 at 6:27:27 PM UTC+5:30, jignesh.a...@gmail.com > wrote: >> >> >> Respected All, >> >> please help me to separate the require number or

$$Excel-Macros$$ Re: how to sum colored cell only

2016-10-08 Thread Mahesh Patil
In the attached sheet the sum range is given. but the reference colour is not provided basis which the sum is to be done. On Saturday, October 8, 2016 at 5:39:32 PM UTC+5:30, GENIUS wrote: > > I have applied the formula but not working, you may see the result in the > attachment. > -- Are yo

Re: $$Excel-Macros$$ VBA : How to create array dynamically

2014-12-02 Thread Mahesh Patil
having name mentioned in each 'cell of range X. Pls suggest solution Regards, Mahesh Patil On Dec 1, 2014 6:33 PM, "Paul Schreiner" wrote: > First of all, it LOOKS like you're wanting to create a two dimensional > array. > This is "normally" handled

$$Excel-Macros$$ VBA : How to create array dynamically

2014-12-01 Thread Mahesh Patil
arname(2) ="city" For i= 0 T0 2 arname(i) (50) as string Next i End sub Thanks. Regards, Mahesh Patil -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORU

Re: $$Excel-Macros$$ Need help to copy data from excel to notepad (Retain carriage return characters and delete non printable characters)

2014-09-20 Thread Mahesh Patil
> > On Sat, Sep 20, 2014 at 12:16 PM, Mahesh Patil wrote: > >> Hi Experts, >> I need to copy data from excel to notepad. The pasted data in notepad >> should be exact replica of copied data from excel (i.e. tabs, carriage >> return to be retained while pastin

Re: $$Excel-Macros$$ Need a Macro to find Variable Cost

2014-09-08 Thread Mahesh Patil
Hi, PFA On Mon, Sep 8, 2014 at 2:52 PM, Shaik Waheed wrote: > Hi friends, > > I need your help to create a macro, its motive is to find out the variable > cost of physicians >4000. > > Attached is the sample data for your reference. > > Thanks in advance. > > Waheed > > -- > Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Highlighted rows will be copy and paste in Sheet 2

2014-09-04 Thread Mahesh Patil
Hey Ashu, Please Find Attached file. I hope it is what you expecting. Regards, Mahesh On Wed, Sep 3, 2014 at 9:11 PM, Ashu k wrote: > Dear Sir, > > I have Data Table in Sheet 1, I want that, when i highlight rows in > sheet 1, these highlighted rows will copy and paste in Sheet 2. > > Data wil