$$Excel-Macros$$ Need help in Mid function

2014-05-01 Thread Ashish Bhalara
Dear experts, I need the middle value between two particular word as per below sentence. Sentence:Being amt. of claim *incentive for CE of Apr-14* claim receivable from TDL. Output of function should be "incentive for CE of Apr-14" The two particular word is "amt. of" & "claim receivable" Tha

Re: $$Excel-Macros$$ Vlookup get numbers from different table

2014-05-01 Thread Vaibhav Joshi
Great work!! On Fri, May 2, 2014 at 12:13 PM, amar takale wrote: > thanks vabs brother > > I try to solve this issue & I wish to share this sheet with you. > > Regards > Amar > > On Thu, May 1, 2014 at 10:57 AM, Vaibhav Joshi wrote: > > Hi Amar, > > > > Yes it is possible, but Excel Name doesn

Re: $$Excel-Macros$$ Vlookup get numbers from different table

2014-05-01 Thread amar takale
thanks vabs brother I try to solve this issue & I wish to share this sheet with you. Regards Amar On Thu, May 1, 2014 at 10:57 AM, Vaibhav Joshi wrote: > Hi Amar, > > Yes it is possible, but Excel Name doesnt accept spaces in between hence you > will be required to do more work to get it done.

$$Excel-Macros$$ changed email address

2014-05-01 Thread isabelle_mamet
Please note that due to excessive Spam, I had to change my email address from isabelle_ma...@edev.co.uk to isabelle-ma...@edev.co.uk (- instead of _)   A cause d'un exces de spam, j'ai du changer mon adresse email de isabelle_ma...@edev.co.uk a isabelle-ma...@edev.co.uk (remplacer le _ par -)

Re: Fwd: $$Excel-Macros$$ Value need to update as per master (excel sheet Attached)

2014-05-01 Thread Paul Schreiner
I'm not sure your explanation is any clearer You said:   "I have one macro by that macro some value get calculate and it will be any number, " So, it could be 41760.2759594907 ? or will it be from the list of target% values? once that number appears in 1 cell then next cell is the "next cell" the