$$Excel-Macros$$ changed email address

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: $$Excel-Macros$$ Macro to look for x in Columns and paste data in worksheet in various folders

Dear Vabz, Thanks a lot for your time and effort. At present when I run the Macro it creates Folder1, Folder2 etc in Documents Folder and some Excel files in the same folder. But maybe I need to explain my requirements once again …hope I will be clear this time. 1. The macro sho

$$Excel-Macros$$ Conditional formatting for color cell

-- 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 FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

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

Are you looking for a workseet function or VBA solution?   If you need a worksheet function, I used this logic: A1 = "Being amt. of claim incentive for CE of Apr-14 claim receivable from TDL."   in a cell named "AmtofClaim" I used the formula: =FIND("amt. of claim",A1) + 14 (14 is the length of "am

$$Excel-Macros$$ Re: need solution by IF and lookup fundtion

Hi Ashish, See if the attached file helps ~BR On Friday, 2 May 2014 09:08:57 UTC+1, Ashish_Bhalara wrote: > > Dear experts, > > Please see the attached file, Input sheet contain selection and Output > sheet is a result from Input sheet. I need output in yellow cell as per > selection in Input s

$$Excel-Macros$$ Upto Rs 700 off on first 500 purchases

The first 500 users who will like the page and will buy from the page will get special coupon code in their inbox to avail upto rs 700 off on the first purchase. The link to facebook page is: https://www.facebook.com/pages/Style-Sutra/664564650256681 Regards Style Sutra -- Are you =EXP(E:RT) o

$$Excel-Macros$$ need solution by IF and lookup fundtion

Dear experts, Please see the attached file, Input sheet contain selection and Output sheet is a result from Input sheet. I need output in yellow cell as per selection in Input sheet by function of IF or any else. Thanks in advance Regards. Ashish Bhalara 9624111822 P*Please do not print this emai

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

thanks vabs brother On Fri, May 2, 2014 at 12:20 PM, Vaibhav Joshi wrote: > 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 1

$$Excel-Macros$$ ImageList Control on Userform in Excel 2013

Hi Everyone, I am working on a form that uses a Listview control and an ImageList control. I would like to be able to add images to the ImageList control and keep them there forever. I have not used this control in a long time but I remember that it used to be possible to 'load' the control wit

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

Hi You can use SUBST function in this case. Cheers!! On Fri, May 2, 2014 at 12:21 PM, Ashish Bhalara wrote: > 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.