Re: $$Excel-Macros$$ Allocating plots of Lands

2015-02-08 Thread Kanwaljit Singh Dhunna
Yes Vaibhav ! As Usual you are right ! On Sun, Feb 8, 2015 at 10:47 PM, Vaibhav Joshi wrote: > Also you can do using solver > > On Sun, Feb 8, 2015 at 12:00 AM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hello Sir, >> >> 2858 hectares to be allocated between three surveyors.

Re: $$Excel-Macros$$ Require function for lookup value on condition.

2015-02-08 Thread Sandeep Sharma
Thanks Vaibhav. Sir, I want to learn VBA so, suggest me where from start. With Regards Sandeep Kumar Sharma *“Always laugh when you can. It is cheap medicine.*” On Sun, Feb 8, 2015 at 10:39 PM, Vaibhav Joshi wrote: > really good Sandeep > > > On Sun, Feb 8, 2015 at 3:37 PM, Sandeep Sharma

Re: $$Excel-Macros$$ Allocating plots of Lands

2015-02-08 Thread Vaibhav Joshi
Also you can do using solver On Sun, Feb 8, 2015 at 12:00 AM, Kanwaljit Singh Dhunna wrote: > Hello Sir, > > 2858 hectares to be allocated between three surveyors. i.e., approx 952 > hectares for each surveyors. > > http://summatch.com/Admin_Pages/DownloadSumMatch.aspx > might help you. > >

Re: $$Excel-Macros$$ Require function for lookup value on condition.

2015-02-08 Thread Vaibhav Joshi
really good Sandeep On Sun, Feb 8, 2015 at 3:37 PM, Sandeep Sharma wrote: > Kindly check this Non-Array solution. > > > > With Regards > Sandeep Kumar Sharma > > *“Always laugh when you can. It is cheap medicine.*” > > On Sat, Feb 7, 2015 at 9:26 PM, Vaibhav Joshi wrote: > >> Check this...

Re: $$Excel-Macros$$ Macro Required

2015-02-08 Thread Vaibhav Joshi
Dont know about Superman but I m definitely Salman Khan's fan !! ;))) Cheers!! On Sun, Feb 8, 2015 at 10:00 PM, B Sharma wrote: > Hii Vaibhav, > > Happy to know that you are a CA too. That means you are a superman in > accounting line. Because if a person is qualified CA and have good hands on

Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

2015-02-08 Thread Vaibhav Joshi
Hi Paul J Irwin, Solution given is based on then requirement... Yes you can have search box in forms too Check this attachment... Cheers!! On Sun, Feb 8, 2015 at 7:21 PM, Paul I wrote: > Hi Vabs, > > This doesnt do the same thing as > http://trumpexcel.com/2013/10/excel-drop-down-list-wi

Re: $$Excel-Macros$$ Macro Required

2015-02-08 Thread B Sharma
Hii Vaibhav, Happy to know that you are a CA too. That means you are a superman in accounting line. Because if a person is qualified CA and have good hands on excel/vba, that means he can do 8 hrs work in just 1 hr. I am neither a CA nor a VBA expert but have good hands on excel, little bit of

Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

2015-02-08 Thread Paul I
Hi Vabs, This doesnt do the same thing as http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/ The beauty of the method in the above linked is that it does not matter if the string you have started typing is part of the second, first, or any word, it will find that stri

Re: $$Excel-Macros$$ Require function for lookup value on condition.

2015-02-08 Thread Sandeep Sharma
Kindly check this Non-Array solution. With Regards Sandeep Kumar Sharma *“Always laugh when you can. It is cheap medicine.*” On Sat, Feb 7, 2015 at 9:26 PM, Vaibhav Joshi wrote: > Check this... > > On Fri, Feb 6, 2015 at 11:08 AM, Ashish Bhalara > wrote: > >> Dear experts, >> >> I require f

Re: $$Excel-Macros$$ Help required - alternate sorting

2015-02-08 Thread Vaibhav Joshi
Great..Cheers! On Sun, Feb 8, 2015 at 1:20 PM, singla.kris...@gmail.com < singla.kris...@gmail.com> wrote: > Hi Vabz, > > Thank you very much That worked like wonder... > > Many thanks > > -- > 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) ! J